Date Formats

(/)	Date seperator. This seperates years, months and days when date values are formatted
ddddd	Displays the date as a complete date (day, month & year) formatted to a long date setting. The default for Windows is "m/d/y"
dddddd	Displays a date serial number as a complete (day, month & year) formatted to a long date setting. The default for Windows is "mmmm dd, yyyy"
c	Displays the date as "ddddd" and displays the time as "ttttt", in that order
d	Displays the day as a number without a leading zero (1 - 31)
dd	Displays the day as a number with a leading zero (01 - 31)
ddd	Displays the day as an abbreviation (Sun - Sat)
dddd	Displays the day as a full name (Sunday - Saturday)
w	Displays the day of the week as a number (1 for Sunday - 7 for Saturday)
ww	Displays week of the year as a number (1 - 54)
m, M	Displays the day of the month as a number without a leading zero (1-12). If "m" immediately follows "h" or "hh" then the minute is displayed rather than the month
mm	Displays the month as a number with a leading zero (01 - 12)
mmm	Displays the month as an abbreviation (Jan - Dec)
mmmm	Displays the month as a full name (January - December)
q	Displays the quarter of the year as a number (1 - 4)
y	Displays the day of the year as a number (1 - 356)
yy	Displays the year as a 2-digit number (00 - 99)