Value Format Patterns for Dates and Times

Follow

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

Have more questions? Submit a request

Comments

Powered by Zendesk