|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 16th, 2004, 09:37 AM
|
|||
|
|||
|
Getting a date value a week from now
hi i have a query in which i want to show all the records which have a date value <= 7 days from now. I'v tried <=Now()+7 in the criteria field??? can anyone help i'm really stuck
|
|
#2
February 16th, 2004, 09:47 AM
|
||||
|
||||
|
Access will return value for date equations as follows
when currenttime is 02/16/04 9:20:33 PM ?now()+7 02/23/04 9:17:33 PM ?date()+7 02/23/04 and 02/23/04 refers to 02/23/04 00:00 AM so use <= date()+8 Quote:
__________________
V.Subramanian
|
|
#3
February 16th, 2004, 09:54 AM
|
|||
|
|||
|
Quote:
I've tried this and no luck it still brings up all records. I've tried using <=Date()+7 but i'm iven an error saying date is undefined???? which i find very strange do you know why it would say his???
|
|
#4
February 16th, 2004, 10:02 AM
|
||||
|
||||
|
Check whether your field in the table has datatype Date/Time
If it is so it should work. If you still have problem then post the query and table structure.
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Getting a date value a week from now |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
