Reading System Date

[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)?

 

[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)?

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())