Convert

Convert a date and time to various formats.

Input

Field Definition Type Required

start

Date and time text in ISO format, or a date and time object in one of the common date and time text formats that automatically convert.

Text

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 to format a time as 09:05 am.

See Format Codes.

Text

FALSE

zone

A TZ time zone, such as US/Pacific or Europe/Paris.

Text

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.

Text

epoch

Date and time in epoch format. Seconds are counted since January 1, 1970, midnight UTC/GMT, not counting leap seconds.

Text

unix

Date and time in milliseconds counted since January 1, 1970, midnight in the UTC/GMT time zone.

Text

human

Human readable date and time, but not adjusted for local time zone.

Text

custom

Text of the date in the format specified by the format and zone input fields.

Text

  • 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.

  • To convert a Unix time to a date, use the Text to Date function instead of Convert.

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 with the format and zone inputs works the same as the Date To Text function.

Related topics

Functions

Workflow elements