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) |