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. |