Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Dates

Author  Topic 

extremekid
Starting Member

1 Post

Posted - 2004-02-16 : 10:35:29
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

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2004-02-17 : 05:44:17
You want to investigate dateadd...or the msaccess equivalent of that MSSQL command.
Also...Now() includes the time portion of today....hh:mm:ss:sss.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-17 : 11:25:07
dateColumn <= DateAdd("d", -7, Now())




Brett

8-)
Go to Top of Page
   

- Advertisement -