3 Date and time functions
All functions listed here are supported in:
Date and time functions cannot be used in the expression alone; at least one non-time-based function referencing the host item must be present in the expression.
The functions are listed without additional information. Click on the function to see the full details.
| Function | Description |
|---|---|
| date | The current date in YYYYMMDD format. |
| dayofmonth | The day of month in range of 1 to 31. |
| dayofweek | The day of week in range of 1 to 7. |
| now | The number of seconds since the Epoch (00:00:00 UTC, January 1, 1970). |
| time | The current time in HHMMSS format. |
Function details
date
The current date in YYYYMMDD format.
Example:
dayofmonth
The day of month in range of 1 to 31.
Example:
dayofweek
The day of week in range of 1 to 7 (Mon - 1, Sun - 7).
Example (only weekdays):
Example (only weekend):
now
The number of seconds since the Epoch (00:00:00 UTC, January 1, 1970).
Example:
time
The current time in HHMMSS format.
Example (only nighttime, 00:00-06:00):