Date functions allow you to create, format, extract, calculate, and manipulate date and time values.
| NAME | DESCRIPTION |
|---|---|
| DATEADD | Adds a specified number of days to the input date |
| DATEDIFF | Returns the number of days between two input dates |
| DAY | Extracts the day of the month from an input date |
| EOMONTH | Returns a date specifying the last day of the month |
| FROMEXCELDATE | Converts an input date to a excel format date serial number |
| MONTH | Extracts the month from an input date |
| NOW | Returns the current date and timestamp |
| PERIOD_RANGE | Returns an array of date ranges between two specified dates |
| TOEXCELDATE | Converts an excel recognized serial number to the equivalent date |
| YEAR | Extracts the year from an input date |
