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) |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext