Custom Date Formats

Learn how to define custom date formats in Date fields.

Written by Paras
Updated over a week ago

You can set highly custom date formats with the following syntax and presets.

Examples

The following are some examples of some popular formats.

`YYYY-MM-DD`	2014-01-01
`dddd, MMMM Do YYYY`	Friday, May 16th 2014
`dddd [the] Do [of] MMMM`	Friday the 16th of May

Presets

These formats are useful presets that can be used to define common formats.

`LT`	8:30 PM
`LTS`	8:30:25 PM
`LL`	August 2 1985
`ll`	Aug 2 1985
`LLL`	August 2 1985 08:30 PM
`lll`	Aug 2 1985 08:30 PM
`LLLL`	Thursday, August 2 1985 08:30 PM
`llll`	Thu, Aug 2 1985 08:30 PM

Date format syntax

You can mix and match the following syntax to create highly custom date formats.

`d`	`0`..`6`	Weekday
`dd`	`Su`
`ddd`	`Sun`
`dddd`	`Sunday`
`YY`	`13`	Year
`YYYY`	`2013`
`M`	`1`..`12` (Jan is 1)	Month
`Mo`	`1st`..`12th`
`MM`	`01`..`12` (Jan is 1)
`MMM`	`Jan`
`MMMM`	`January`
`Q`	`1`..`4`	Quarter
`Qo`	`1st`..`4th`
`D`	`1`..`31`	Day
`Do`	`1st`..`31st`
`DD`	`01`..`31`
`DDD`	`1`..`365`	Day of year
`DDDo`	`1st`..`365th`
`DDDD`	`001`..`365`
`w`	`1`..`53`	Week of year
`wo`	`1st`..`53rd`
`ww`	`01`..`53`