Date/Time Masks |
The mask values apply to all date manipulation
functions; Now(), GetTime(), and GetDate().
|
|
e | Use English names (e is first character in mask) |
f | Use French names (f is first character in mask) |
g | Use German names (g is first character in mask) |
|
+num | num is offset in hours (+ must be first or second character in mask) |
-num | num is offset in hours (- must be first or second character in mask) |
|
d | Non-zero padded month day number (1-31) |
dd | Zero padded month day number (01-31) |
ddd | Abbreviated weekday name |
dddd | Long weekday name |
|
m | Non-zero padded month number (1-12) |
mm | Zero padded month number (01-12) |
mmm | Abbreviated month name |
mmmm | Long month name |
|
y | Non-zero padded year (0-99) |
yy | Zero padded year (00-99) |
yyy | Day of year as decimal number (1-366) |
yyyy | Four digit year number |
|
h | Non-zero padded number of hours (0-11) |
hh | Zero padded number of hours (00-11) |
H | Non-zero padded number of hours (0-23; 24 hour clock) |
HH | Zero padded number of hours (0-23; 24 hour clock) |
M | Non-zero padded number of minutes (0-59) |
MM | Zero padded number of minutes (00-59) |
S | Non-zero padded number of seconds (0-59) |
SS | zero padded number of seconds (00-59) |
z | AM/PM specifier as a single letter (a or p) |
zz | AM/PM specifier as two letters (am or pm) |
|
\ | Escape next character (eg. '\d' will translate to 'd') |