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 alone; at least one non-time-based function referencing the host item must be present in the expression.
| 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 |
|