Reading System Date

N

Neo

What synatx to use in a query (as part of a calculation) in order for the
query to automatically read the computer's system date (instead of asking the
user to input it)?
 
F

fredg

What synatx to use in a query (as part of a calculation) in order for the
query to automatically read the computer's system date (instead of asking the
user to input it)?
Click to expand...

Date()

For example, to calculate the number of months between a date field
and the current date in a query, you could use:

ElapsedMonths: DateDiff("m",[DateField],Date())
 
Top