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 |