Table of Contents
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.
| FUNCTION | ||
|---|---|---|
| Description | Function-specific parameters | Comments |
| date | ||
| Current date in YYYYMMDD format. | Example: => date()<20220101 |
|
| dayofmonth | ||
| Day of month in range of 1 to 31. | Example: => dayofmonth()=1 |
|
| dayofweek | ||
| Day of week in range of 1 to 7 (Mon - 1, Sun - 7). | Example (only weekdays): => dayofweek()<6 Example (only weekend): => dayofweek()>5 |
|
| now | ||
| Number of seconds since the Epoch (00:00:00 UTC, January 1, 1970). | Example: => now()<1640998800 |
|
| time | ||
| Current time in HHMMSS format. | Example (only nighttime, 00:00-06:00): => time()<060000 |
|