The following table describes the elements that can be included in a Date Picture. Examples are shown in Date Picture Examples.
| Clause | Picture | Result |
|---|---|---|
| Day | d | Integer between 1 and 31, corresponding to day of month. Does not display leading zeroes. |
| dd | Integer between 1 and 31, corresponding to day of month. Displays leading zeroes. | |
| ddd | Integer between 1 and 365 (366 in a leap year), corresponding to number of days since first of the year. Does not display leading zeroes. | |
| Month | m | Integer between 1 and 12, corresponding to a month. Note that this format does not display leading zeroes. |
| mm | Integer between 1 and 12, corresponding to a month. Displays leading zeroes. | |
| mmm | A three character abbreviation for the month corresponding to stored month number (for example: JAN, FEB, MAR,...). | |
| mmmm | Month corresponding to the stored month number (for example: January, February, March,...). | |
| Year | yy | Displays last two digits of stored year. |
| yyyy | Displays the stored year. | |
| Weekday | ww | An integer corresponding to the day of the week (Monday=1, Tuesday=2, etc.) |
| www | Three-character abbreviation for the day of the week (for example: MON, TUE, WED,...). | |
| wwww | The day of the week a date falls on. |