|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 25th, 2008, 09:44 PM
posted to microsoft.public.access.queries
|
|||
|
|||
=(Now()-1)
What does this mean in criteria for date? Thanks
|
|
#2
August 25th, 2008, 09:56 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
=(Now()-1)
On Mon, 25 Aug 2008 13:44:07 -0700, Novice2000 wrote:
What does this mean in criteria for date? Thanks It means the query should return those records whose date field has a date value greater than or equal to yesterday at whatever time of day you are running the query. In other words, if you run the query today (8/25/2008) at 1:50 PM, it will return all record between 8/24/2008 1:50 PM on into the future. Records with a time value of 1:49 PM and earlier will not be returned. Most often, the time value is not a part of a date entry, so it's best to use Date() instead of Now(). = Date()-1 will return all return all records from yesterday on into the future, regardless of the time the query is run. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
