Convert

Convert a date and time to a variety of formats.

Input

Field Definition Type Required
start Date and time text in ISO format or a date and time object in many common date and time text formats that will automatically convert. String TRUE
format Date format that indicates how to display the date or the time, such as M/D/Y to produce 9/7/2016 or hh:mm a for a time such as 09:05 am. See Date to Text for format codes. String FALSE
zone A TZ time zone such as US/Pacific or Europe/Paris. String FALSE

Output

Field Definition Type
date Date and time object that corresponds to the start value. Date & Time
iso Converted date and time in ISO format, but without fractional seconds. For example, 2016-09-07T16:55:25.670Z. String
epoch Date and time in epoch format. Seconds are counted since January 1, 1970, midnight UTC/GMT, not counting leap seconds. String
unix Date and time in milliseconds counted since January 1, 1970, midnight UTC/GMT. String
human Human readable date and time, but not adjusted for local time zone. String
custom Text of the date in the format specified by the format and zone input fields. String

The input fields format and zone work only with the output field custom. See the Date to Text function for details and examples of how to generate custom formatted dates and times as text. Using the custom output field is equivalent to using the Date To Text function.

Example

If the start is 2016-09-07T00:01:25.670Z, then:

  • date is 2016-09-07T00:01:25.670Z

  • iso is 2016-09-07T00:01:25Z

  • epoch is 1473206485

  • unix is 1473206485670

  • human is Wed, September 7th at 12:01 AM

See the Date to Text function for examples for the custom output field. The custom output in combination with the format and zone inputs works the same as Date To Text.

Related topics

Functions in Workflows

Workflow elements