This is a translation of the original English documentation page. Help us make it better.

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:

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:

dayofweek()<6
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:

time()>000000 and time()<060000

See all supported functions.