Date to Text
Convert a date and time into a provided format in a specified timezone.
Input
| Field | Definition | Type | Required |
|---|---|---|---|
| start | Date and time value to be formatted. | Date & Time | TRUE |
| format |
Date format code of the input value for the start field such as M/D/Y to produce 9/7/2016 or hh:mm a for a time such as 09:05 am. See below for format codes.
|
String | TRUE |
| zone | A TZ time zone such as US/Pacific or Europe/Paris. |
String | TRUE |
Output
| Field | Definition | Type |
|---|---|---|
| output | Text of the date in the chosen format in the designated timezone. | String |
Format Codes
Build the format for the date and/or time format that you want by using any combination of these codes along with fixed characters such as slashes and commas.
| format codes | output |
|---|---|
|
D |
For day number (in the month) or DD to always show it using two digits. |
| M | For month number or MM for always two digits. |
| MMM | For three letter month name abbreviation or MMMM for full month name. |
| Y | For four-digit year number or YY for a two-digit year number. |
| h | For hour number (1-12) or hh to always show it using two digits. |
| H | For hour number (0-23) or HH to always show it using two digits. |
| mm | For minutes. |
| ss | For seconds (and add .S's to include milliseconds; for example, ss.SSS). |
| a | For am or pm or A for AM or PM. |
| Z | For timezone in offset format (for example, -07:00) or z for code (for example, PDT). |
| d | For day of the week (1=Monday), ddd for day abbreviation (for example, Mon) or dddd for full day name (for example, Monday). |
Examples
If the ISO start date is 2016-09-07T00:01:25.670Z and the time zone is America/Pacific then do the following:
| format | output |
|---|---|
| M/D/Y |
9/6/2016 |
| h:mm a z | 9:01 am PDT |
| dddd, MMMM D, Y | Wednesday, September 7, 2016 |
| D-MMM-YY HH:mm:ss.S z | 7-Sep-16 09:01:25.6 PDT |
If you want to format the current date and time, use a Now card and drag and drop the date field from the Now card into the start field on the Date To Text card.