The following functions return a date.
| Function | Result |
|---|---|
| DateRoll | To the given date, rolls (adds or subtracts) a number of specific time intervals, returning another date. |
| GetFirstDate | Returns the start date for a date-hierarchy member. |
| GetLastDate | Returns the end date for a date-hierarchy member. |
| GetNextDay | To the given date and the week day, gets the next date after input date that corresponds to the week day. |
| GetFirstDay | For a given date_part, returns the first day of the time interval for the input date. |
| GetLastDay | For a given date_part, returns the last day of the time interval for the input date. |
| TodateEx | Converts date strings to dates. |
| Today | Returns a number representing the current date. |
| JulianDate | For the given UNIX date, gets its Julian date. |
| UnixDate | For the given Julian date, gets its UNIX date. |