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: Feb 11, 2010 12:00 AM Examples The following example calculates the number of days from the current date to Christmas: DIFF_DAY(TODAY(), "12/25/10") The following example calculates the number of years from each value in the HireDate field to the current date: DIFF_YEAR([HireDate], TODAY())