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.
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. |
 |
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-17 : 11:25:07
|
dateColumn <= DateAdd("d", -7, Now())Brett8-) |
 |
|
|
|
|