Date and time functions

Save PDF

Last UpdatedSep 29, 2026
2 minute read

Function / Aliases	Return	Description	Example
NOW	DateTime	Current date and time	{{ now }} Result: 2026-05-18 18:41:36.2998052
UTC / ToUTC	DateTime	Converts a date and time to UTC	{{ Now.ToUTC }} Result: 2026-05-18 14:43:49.6745141
DATE / GETDATE	Date	Date without time info	{{ now.date }} Result: Returns date only
DATESTAMP / GETDATESTAMP	String	Date as yyyyMMdd	{{ now.dateStamp }} Result: 20240501
TIMESTAMP / GETTIMESTAMP	String	Date timestamp as yyyyMMdd-HHmmss	{{ now.timestamp }} Result: 20240501-132015
DAY / DAYOFMONTH / GETDAY	Int	Day of month	{{ now.day }} Result: Returns day number
DAYOFYEAR	Int	Day of the year as a number	{{ Now.DayofYear }} Result: Returns day of the year as a number
DAYOFWEEK	String	The name of the day of week	{{ now.dayOfWeek }} Result: Wednesday, etc.
MONTH / GETMONTH	Int	Returns the month part of a date	{{ now.month }} Result: 1-12
YEAR / GETYEAR	Int	The Year part of the date	{{ now.year }} Result: 2026
TOISODATE / TOSTDDATE / TOSTANDARDDATE	String	Convert to ISO 8601 format	{{ @[DateField].toStdDate('dd/MM/yyyy') }} Result: 23/05/2026 8:18:19 PM
ISOTIMESTAMP		Convert to ISO 8601 date timestamp format	{{ Now.isoTimestamp }} Result: 2026-05-23T20:11:14
STDTIMESTAMP / STANDARDTIMESTMAP		Convert to standard date timestamp format	{{ Now.STDTIMESTAMP }} Result: 2026-05-23 20:11:14
CONVERTDATE	String	Convert from one format to another	{{ @[Field].convertDate('dd/MM/yyyy','MM/dd/yyyy') }} Result: Convert date between formats
ADDDAYS	DateTime	Add N days to date	{{ now.addDays(7) }} Result: Add 7 days to current date
ADDMONTHS	DateTime	Add N months to date	{{ now.addMonths(3) }} Result: Add 3 months
ADDYEARS	DateTime	Add N years to date	{{ now.addYears(1) }} Result: Add 1 year
ISDATE	Bool	Returns true if the input text looks like a date	{{ Now.isDate }} Result: true
ISAFTER		Compare one date after another	{{ Now.adddays(1).isAfter(now)}} Result: true
ISBEFORE		Compare if one date is before another	{{ Now.isBefore(now.adddays(1)) }} Result: true
LASTDAYOFMONTH		Return the last day of the month	{{ Now.LASTDAYOFMONTH }} Result: 2026-05-31 00:00:00.0000000

Registers Gateway

Date and time functions

Table of Contents

Date and time functions

Related Links