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:
date()<20220101dayofmonth
The day of month in range of 1 to 31.
Example:
dayofmonth()=1dayofweek
The day of week in range of 1 to 7 (Mon - 1, Sun - 7).
Example (only weekdays):
dayofweek()<6Example (only weekend):
dayofweek()>5now
The number of seconds since the Epoch (00:00:00 UTC, January 1, 1970).
Example:
now()<1640998800time
The current time in HHMMSS format.
Example (only nighttime, 00:00-06:00):
time()<060000