Documentation
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: => dayofweek()<6 |
||
| now | |||
| Number of seconds since the Epoch (00:00:00 UTC, January 1, 1970). | Example: => now()<1640998800 |
||
| time | |||
| Current time in HHMMSS format. | Example: => time()>000000 and time()<060000 |
||
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:
now
The number of seconds since the Epoch (00:00:00 UTC, January 1, 1970).
Example:
time
The current time in HHMMSS format.
Example: