Date and time commands

This topic has a comprehensive list of commands to manipulate date and time variable types. You can convert types, calculate date differences, add or subtract values from Date Time variables, among other actions.

Calculate Date Difference (dateDifference) command
Calculates the time interval between two Date Time values. Returns a Time Span variable.

Convert Date Time to Text (dateTimeToText) command
Converts the value of a Date Time variable into a Text variable. You can apply custom formatting.

Convert Text to Date Time (textToDateTime) command
Converts the value of a Text variable into a Date Time variable. You can use custom formatting.

Add Value to Date Time (addToDateTime) command
Adds a value as years, months, days, hours, minutes, or seconds to the value of a Date Time variable. You can use negative numbers.

Get Date From Date Time (dateTimeToDate) command
Gets the date portion from the value of a Date Time variable.

Get Current Date and Time (getCurrentDateAndTime) command
Returns the current date and time value as a Date Time variable. You can choose between your local time or the UTC+0 time.

Get Date Time Part (getDatePart) command
Returns the number value that defines either the year, month, day, hour, minute, or second from the value of a Date Time variable.