Home > Expression Operators > Date Operators

Date Operators

Click the name of an operator (name begins with a pound sign) to learn more: 

12/31/1992 example of a date  constant (December 31, 1992)
3y2m15d example of a duration  (3 years, 2 months, 15 days)
   
#DATEMINUS Subtracts a duration from a date.
#DATEPLUS Adds a duration to a date.
#MONTHDIF Returns the number of months between two dates; may be fractional.
#YEARDIF Returns the number of years between two dates; may be fractional.
#DAY Extracts the day from a date.
#MONTH Extracts the month from a date.
#YEAR Extracts the year (4 digits) from a date.
#BEGMTH Returns the date of the first day of the month in which Date falls.
#ENDMTH Returns the date of the last day of the month in which Date falls.
#NEXTBEGMTH Returns the date of the first day of the month coincident with or next following Date.
#MONTHROUND Rounds a date to the start of an n-month period.