Date Formats in Rule Expressions

What follows are the format string that can be used in Date functions in Rule Expressions.

Standard Format Tokens

Format	Output	Description
`YY`	18	Two-digit year
`YYYY`	2018	Four-digit year
`M`	1-12	The month, beginning at 1
`MM`	01-12	The month, 2-digits
`MMM`	Jan-Dec	The abbreviated month name
`MMMM`	January-December	The full month name
`D`	1-31	The day of the month
`DD`	01-31	The day of the month, 2-digits
`d`	0-6	The day of the week, with Sunday as 0
`dd`	Su-Sa	The min name of the day of the week
`ddd`	Sun-Sat	The short name of the day of the week
`dddd`	Sunday-Saturday	The name of the day of the week
`H`	0-23	The hour
`HH`	00-23	The hour, 2-digits
`h`	1-12	The hour, 12-hour clock
`hh`	01-12	The hour, 12-hour clock, 2-digits
`m`	0-59	The minute
`mm`	00-59	The minute, 2-digits
`s`	0-59	The second
`ss`	00-59	The second, 2-digits
`SSS`	000-999	The millisecond, 3-digits
`Z`	+05:00	The offset from UTC, ±HH:mm
`ZZ`	+0500	The offset from UTC, ±HHmm
`A`	AM PM	Post or ante meridiem, upper-case
`a`	am pm	Post or ante meridiem, lower-case

Format	Output	Description
`Q`	1-4	Quarter
`Do`	1st 2nd ... 31st	Day of Month with ordinal
`k`	1-24	The hour, beginning at 1
`kk`	01-24	The hour, 2-digits, beginning at 1
`X`	1360013296	Unix Timestamp in second
`x`	1360013296123	Unix Timestamp in millisecond
`w`	1 2 ... 52 53	Week of year
`ww`	01 02 ... 52 53	Week of year, 2-digits
`W`	1 2 ... 52 53	ISO Week of year
`WW`	01 02 ... 52 53	ISO Week of year, 2-digits
`wo`	1st 2nd ... 52nd 53rd	Week of year with ordinal
`gggg`	2017	Week Year
`GGGG`	2017	ISO Week Year
`z`	EST	Abbreviated named offset
`zzz`	Eastern Standard Time	Unabbreviated named offset