Date Functions

Date built-in functions perform date processing in eight formats:

Gregorian— The first format is yymmdd, where yy represents a year, mm a month, and dd a day.
The second Gregorian format is yyyymmdd, where yyyy represents a year in any century, mm a month, and dd a day.
Calendar— The first format is mmddyy, where yy represents a year, mm a month, and dd a day.
The second Calendar format is mmddyyyy, where yyyy represents a year in any century, mm a month, and dd a day.
European— The first format is ddmmyy, where yy represents a year, mm a month, and dd a day.
The second European format is ddmmyyyy, where yyyy represents a year in any century, mm a month, and dd a day.
Julian— The first format is yyddd, where ddd is a day in the year from 1 to 365 (366 for leap years).
The second Julian format is yyyyddd, where yyyy represents a year in any century, and ddd is a day in the year from 1 to 365 (366 for leap years).

Function	Keyword	What it does
Date change	DATECHG	Returns Gregorian, calendar, European, or Julian date conversions
Date difference	DATEDIF	Returns the number of days between two specified dates
Date offset	DATEOFF	Returns the date resulting from adding a specified number of days to a date
Good date	GOODDATE	Returns TRUE or FALSE to indicate whether a date is valid for the date type
Today's date	TODAY	Returns today's date in the specified format
Tomorrow's date	TOMORROW	Returns tomorrow's date in the specified format
Weekday	WEEKDAY	Returns the weekday of a specified date
Yesterday's date	YESTERDAY	Returns yesterday's date in the specified format