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.