3 Date and time functions
All functions listed here are supported in:
Date and time functions cannot be used in the expression by themselves; at least one function from another group, referencing the host item, must be included in the expression (except the nodata() function). For detailed information on how date and time functions work within expressions, see Calculation time.
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):