Date/time utilities

Utilities to calculate current date and time durations.

Calculate time duration

Calculates the time from Date to the present, and returns it in the DATE_FORMAT you defined.

Date_Format

%Y-%m-%dT%H:%M:%S

Date

2006-08-29T23:59:11

Output

138422h29m13.895503549s

Get date

Returns a date in the DATE_FORMAT defined. You can use the optional parameters to set a time in the past, as well as determine the time zone.

Date_Format

%Y-%m-%dT%H:%M:%S

Date

2006-08-29T23:59:11

Output

2022-06-14T14:30:45

Compare dates

To check if the dates are the same, you can use the If or Switch operators and the Equals (or Not Equals) condition.