FormatDate(str,fmt) forces the format of dates and times
Identifier |
Meaning |
|
d |
Displays the number of the day without a leading 0 (1 to 31) |
|
dd |
Displays the number of the day with a leading 0 (01 to 31) |
|
ddd |
Displays the abbreviation of the day (Sun to Sat) |
|
dddd |
Displays the full name of the day (Sunday to Saturday) |
|
m |
|
Displays the number of the month without a leading 0 (1 to 12) |
mm |
|
Displays the number of the month with a leading 0 (01 to 12) |
mmm |
|
Displays the abbreviation of the month (Jan to Dec) |
mmmm |
|
Displays the full name of the month (January to December) |
yy |
|
Displays the year with two digits (00 to 99) |
yyyy |
|
Displays the year with four digits (0000-9999) |
h |
|
Displays the time (hour) without a leading 0 (0 to 23) |
hh |
|
Displays the time (hour) with a leading 0 (00 to 23) |
n |
|
Displays the minutes without a leading 0 (0 to 59) |
nn |
|
Displays the minutes with a leading 0 (00 to 59) |
s |
|
Displays the seconds without a leading 0 (0 to 59) |
ss |
|
Displays the seconds with a leading 0 (00 to 59) |