Date handling |
| Statement/Function | Description |
| WeekStart |
Returns date-of-Monday for week |
| WeekOfYear |
|
| Week |
Returns week-of-year for date |
| Leapyear |
Checks if year is leap-year |
| Day |
Returns day number from date |
| Dayname |
Returns day name for date |
| Dayofweek |
Returns day-of-week for date |
| Dayofyear |
Returns day-of-year for date |
| Dmy |
Returns constructed date value |
| Dmyadd |
Returns date value by adding offsets to start date |
| Month |
Returns month from date |
| MonthName |
Returns month name for date |
| Months |
Returns count of calendar months between dates |
| Year |
Returns year from date |
| Years |
Returns count of whole years between dates |
| ServerDateTime |
Returns the current date/time from the server |
| Today |
Returns current date |