Symbol | Description | Example | Result |
d | Returns day of the month without a leading zero (1‑31) | Day{d}.<document extension> | Day3.<document extension> |
dd | Returns day of the month with a leading zero (01‑31) | Day{dd}.<document extension> | Day03.<document extension> |
ddd | Returns the three‑letter abbreviation for the day of the week | {ddd}.<document extension> | Tue.<document extension> |
dddd | Returns the full name of the day of the week | {dddd} | Tuesday |
ddddd | Returns the short date | {ddddd} | 01/23/2006 |
dddddd | Returns the long date | {dddddd}.<document extension> | Monday, January 23, 2006.<document extension> |
w | Returns the day of the week as a number, where Sunday = 1 and Saturday = 7 | Weekday {w}.<document extension> | Weekday 3.<document extension> |
ww | Returns the week of the year (1‑53) | Week {ww}.<document extension> | Week 4.<document extension> |
m | Returns the number of the month without the leading zero (1‑12) | Month {m}.<document extension> | Month1.<document extension> |
mm | Returns the number of the month with the leading zero | Month {mm}.<document extension> | Month 01.<document extension> |
mmm | Returns the three-letter abbreviation for the month’s name | {mmm}.<document extension> | Jan.<document extension> |
mmmm | Returns the full name of the month | {mmmm}.<document extension> | January.<document extension> |
q | Returns the number of the quarter (1‑4) | Quarter {q}.<document extension> | Quarter 1.<document extension> |
y | Returns the number of the day of the year (1‑365) | Day {y}.<document extension> | Day 23.<document extension> |
yy | Returns the last two digits of the year (00‑99) | Year {yy}.<document extension> | Year 01.<document extension> |
yyy or yyyy | Returns all four digits of the year (1000‑9999) | Year {yyy}.<document extension> | Year 2006.<document extension> |
c | Returns the date variant as dddd | For {dddd} | For 01/23/2006 or for 01‑23‑2006 |