Date to Text

start

Date and time value to be formatted.

format

The date format code of the desired output value, based on the start field.

For example, use M/D/Y to produce 9/7/2016 or hh:mm a for a time like 09:05 am. See Format Codes.

zone

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

output

The date string, in the chosen format and in the designated time zone.

D

For a day number (in the month), or use DD to always display the day using two digits.

M

For a single month number, or use MM to use two digits.

MMM

For a three letter month abbreviation, or use MMMM for the full month name.

Y

For a four-digit year number, or use YY for a two-digit year number.

h

For the hour number (1-12), or use hh to use two digits.

H

For the hour number (0-23), or use HH to use two digits.

mm

For the minutes.

ss

For the seconds. Add an .S to include milliseconds, for example, ss.SSS.

a

For am or pm designation, or use A for AM or PM.

Z

For the time zone in offset format, for example, -07:00. You can also use z for code, for example, PDT.

d

For the day of the week, where 1 is Monday. Use ddd for an abbreviated day format, for example, Mon. Use dddd for the full day name, for example, Monday.

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