Value Format Patterns (Dates/Times)

When a date/time field is defined on a template, you have the option to set a value format pattern for the field. You can either select from the list of commonly used patterns or enter custom patterns.

Date Formatting:

M	Displays the month as a number without a leading zero.
MM	Displays the month as a number with a leading zero when appropriate.
MMM	Displays the month as an abbreviation (Jan to Dec).
MMMM	Displays the month as a full name (January to December).
MMMMM	Displays the month as a single letter (J to D).
d	Displays the day as a number without a leading zero.
dd	Displays the day as a number with a leading zero when appropriate.
EEE	Displays the day as an abbreviation (Sun to Sat).
EEEE	Displays the day as a full name (Sunday to Saturday).
yy	Displays the year as a two-digit number.
yyyy	Displays the year as a four-digit number.

Time Formatting:

h	Displays the hour as a number without a leading zero based on a 12 hour clock.
hh	Displays the hour as a number with a leading zero when appropriate based on a 12 hour clock.
H	Displays the hour as a number without a leading zero based on a 24 hour clock.
HH	Displays the hour as a number with a leading zero when appropriate based on a 24 hour clock.
m	Displays the minute as a number without a leading zero.
mm	Displays the minute as a number with a leading zero when appropriate.
s	Displays the second as a number without a leading zero.
ss	Displays the second as a number with a leading zero when appropriate.
SSS	Displays fractions of a second.
a, aa	Displays the hour using a 12-hour clock with either the a/p or am/pm indicator.
ZZZ	Displays the offset from UTC time

Examples:

To display	As	Use this code
2/15/15	01/15/2015	MM/dd/yyyy
02/15/15	15/2/15	d/m/yy
02/15/15	15 Feb 2015	dd MMM yyyy
02/15/15	Sunday, February 15, 2015	EEEE, MMMM dd, yyyy
1:15 PM	1:15 PM	h:mm aa
1:15 PM	13:15	H:mm
1:15 PM	01:15 p	hh:mm a