Version: 8.1

Date and Time

The following functions allow you to check or modify time values in expression bindings.

📄️ add*

Add or subtract an amount to a given date and time

Adds or subtracts some amount of time from a date, returning the resulting date.

Calculates the difference between the two dates, returning the result as a floating point value in the units specified by field

Returns an integer value that is the value of the specified date field within the given date.

Returns the given date as a string, formatted according to a pattern.

Compares two dates to see if date1 is after date2.

Compares two dates to see if date1 is before date2

Compares two dates to see if a target date is between two other dates.

Checks to see if the current timezone is using daylight savings time during the date specified.

Calculates the amount of time between two dates

Creates a date object given a millisecond value.

Extracts a unit of time from a date

Creates a new Date object given a year, month and a day.

Returns the ID of the current timezone depending on the scope in which it is called.

Returns the current timezone's offset versus UTC for a given instant, taking Daylight Savings Time into account.

Returns the current timezone offset versus UTC, not taking daylight savings into account.

Returns a copy of a date with the hour, minute, second, and millisecond fields set to zero.

Returns the current time.

Takes in a date, and returns a copy of it with the time fields set as specified.

Checks to see if the given time is between the start and end times.

Converts a Date object to its millisecond value elapsed since January 1, 1970, 00:00:00 UTC (GMT)