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
|
|||
|
|||
todays date
I'm trying to run a query based on todays date. What is
the syntax for today in the criteria line. Thanks. |
#2
|
|||
|
|||
todays date
Date() should work, unless your date field contains both date and time data,
as when filled using the Now() function. If that is the case, you should use: BETWEEN Date() AND DateAdd("d", 1, Date()) Or, you could use the DateValue() function to convert your date/time field to contain just the date portion and use Date() in the criteria link. HTH Dale "rml" wrote in message ... I'm trying to run a query based on todays date. What is the syntax for today in the criteria line. Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Disabling today's date on invoice template | Pam | Worksheet Functions | 1 | March 4th, 2004 12:27 PM |
freezing todays date in a function | Dave | Worksheet Functions | 7 | January 18th, 2004 12:52 AM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |