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