- Y
-
- 2 or 4 characters
- 2
Ys indicate a numeric year, such as 14
- 4
Ys indicate a numeric century and year, such as 2014
- M
-
- 2, 3, or 9 characters
- 2
Ms indicate a numeric month, such as 12
- 3
Ms indicate a short character month, such as DEC
- 9
Ms indicate a long character month, such as DECEMBER
- D
-
- 3 characters if you do not define Month, otherwise it must be 2 characters
- 2
Ds indicate a numeric Gregorian day, such as 30
- 3
Ds indicate a numeric Julian day, such as 360
Month, day, and year must be in the same order in both the input and output formats. For example:
Storage Format
|
YYYYMMDD
|
Input Format
|
MMDDYY
|
Output Format
|
MMMMMMMMM DD, YYYY
|