Reading System Date

  • Thread starter Thread starter Neo
  • Start date Start 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)?
 
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())
 
Back
Top