Name | Syntax | Return | Description | Status |
|---|---|---|---|---|
| Table | Returns a table with a single column named "Date" that contains a contiguous set of dates | In progress | |
| Table | Returns a table with a single column named "Date" that contains a contiguous set of dates. | In progress | |
| DateTime | Returns the specified date in datetime format | In progress | |
| DateTime | Converts a date in the form of text to a date in datetime format. | In progress | |
| DateTime | Converts hours, minutes, and seconds given as numbers to a time in datetime format. | In progress | |
| DateTime | Converts a time in text format to a time in datetime format. | In progress | |
| DateTime | Returns the current date | In progress | |
| DateTime | Returns the current date and time in datetime format | In progress | |
| DateTime | Returns the current UTC date. | In progress | |
| DateTime | Returns the current date and time in Coordinated Universal Time (UTC) | In progress | |
| Integer | Returns the day of the month, a number from 1 to 31. | In progress | |
| Integer | Returns the month as a number from 1 (January) to 12 (December) | In progress | |
| Integer | Returns the year of a date as a four digit integer | In progress | |
Integer | Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.) | In progress | ||
| Integer | Returns the minute as a number from 0 to 59, given a date and time value. | In progress | |
| Integer | Returns the seconds of a time value, as a number from 0 to 59. | In progress | |
| Integer | Returns the quarter as a number from 1 to 4 | In progress | |
| Integer | Returns a number from 1 to 7 identifying the day of the week of a date | In progress | |
| Integer | Returns the week number for the given date and year according to the return_type value. | In progress | |
| Integer | Returns the count of interval boundaries crossed between two dates | In progress | |
| DateTime | Returns the date that is the indicated number of months before or after the start date | In progress | |
| DateTime | Returns the date in datetime format of the last day of the month, before or after a specified number of months | In progress | |
| Decimal | Calculates the fraction of the year represented by the number of whole days between two dates | In progress | |
| Integer | Returns the number of whole workdays between two dates. | In progress |