Skip to content

Date and Time Expressions

Date and time information are incredibly valuable in your processes. Not only do you probably require your users to register dates and times, you will also want to automate your process using dynamic time ranges. You might, for instance, only want to show work order for the past two weeks. Or automatically set the current time into a field upon creating a new document. Date - and time expressions will help you achieve just that.

NOW

NOW returns the current time formatted like HH:mm ("12:05").

Syntax

NOW()

Examples

  • NOW() returns the current time formatted like HH:mm. For instance "12:05".
  • NOW()+60 returns the current time plus 60 minutes. For instance "13:05".

TODAY

TODAY() returns the current date formatted like 'YYYY-MM-DD' ("2019-07-18").

Syntax

TODAY()

Examples

  • TODAY() returns the current date formatted like 'YYYY-MM-DD'. For instance "2019-07-18".
  • TODAY()+7 returns the current date plus 7 days. For instance "2019-07-25".

DATE

DATE() returns a date string.

Syntax

DATE(year,month,day)

  • year - the year. This can be a pointer to a field.

  • month - the month. This can be a pointer to a field.

  • day - the day. This can be a pointer to a field.

Examples

  • DATE(2023,12,1) returns "2023-12-01".
  • DATE(2023,12,1)+31 returns "2024-01-01".

TIME

TIME() transforms input into a time string with hours and minutes of format: 'HH:mm'.

Syntax

TIME(hours,minutes)

  • hours - the number of hours. This can be a pointer to a field.

  • minutes - the number of minutes. This can be a pointer to a field.

Examples

  • TIME(12,70) returns the "13:10".
  • TIME(12,70)+60 returns the "14:10".