Date Formats

(/)Date seperator. This seperates years, months and days when date values are formatted
dddddDisplays the date as a complete date (day, month & year) formatted to a long date setting. The default for Windows is "m/d/y"
ddddddDisplays a date serial number as a complete (day, month & year) formatted to a long date setting. The default for Windows is "mmmm dd, yyyy"
cDisplays the date as "ddddd" and displays the time as "ttttt", in that order
dDisplays the day as a number without a leading zero (1 - 31)
ddDisplays the day as a number with a leading zero (01 - 31)
dddDisplays the day as an abbreviation (Sun - Sat)
ddddDisplays the day as a full name (Sunday - Saturday)
wDisplays the day of the week as a number (1 for Sunday - 7 for Saturday)
wwDisplays week of the year as a number (1 - 54)
mDisplays 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
mmDisplays the month as a number with a leading zero (01 - 12)
mmmDisplays the month as an abbreviation (Jan - Dec)
mmmmDisplays the month as a full name (January - December)
qDisplays the quarter of the year as a number (1 - 4)
yDisplays the day of the year as a number (1 - 356)
yyDisplays the year as a 2-digit number (00 - 99)

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext