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