TODAY( )
Returns the current date that includes a time value of midnight, 12:00 AM.
Syntax
TODAY( )
Returns
The current date in the following format:
Sep 25, 2008 12:00 AM
Example
The following example calculates the number of days from the current date to Christmas:
DIFF_DAY(TODAY(), "12/25/08")
The following example calculates the number of years from each value in the HireDate data field to the current date:
DIFF_YEAR([HireDate], TODAY())