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.

The functions are listed without additional information. Click on the function to see the full details.

Function Description
date The current date in YYYYMMDD format.
dayofmonth The day of month in range of 1 to 31.
dayofweek The day of week in range of 1 to 7.
now The number of seconds since the Epoch (00:00:00 UTC, January 1, 1970).
time The current time in HHMMSS format.

Function details

date

The current date in YYYYMMDD format.

Example:

date()<20220101
dayofmonth

The day of month in range of 1 to 31.

Example:

dayofmonth()=1
dayofweek

The day of week in range of 1 to 7 (Mon - 1, Sun - 7).

Example (only weekdays):

dayofweek()<6

Example (only weekend):

dayofweek()>5
now

The number of seconds since the Epoch (00:00:00 UTC, January 1, 1970).

Example:

now()<1640998800
time

The current time in HHMMSS format.

Example (only nighttime, 00:00-06:00):

time()<060000

See all supported functions.