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