You can use the following as delimiters in your date/time:
/ : - _ , . < > ? ; ' { [ ] = ( ) * & ^ % # @ ! ~ ` \ "
You cannot use the right brace or the vertical bar:
} |
|
d |
The day is displayed as a number with no leading zero for single-digit days. |
|
dd |
The day is displayed as a number with a leading zero for single-digit days.
|
|
/DT |
Displays date and time in the following format: |
|
ddd |
The day is displayed as a three-letter abbreviation, specified by the LOCALE_SABBREVDAYNAME registry value.
|
|
dddd |
The day is displayed as specified by the LOCALE_SDAYNAME registry value.
|
|
M |
The month is displayed as a number with no leading zero for single-digit months. |
|
MM |
The month is displayed as a number with a leading zero for single-digit months.
|
|
MMM |
The month is displayed as a three-letter abbreviation, specified by the LOCALE_SABBREVMONTHNAME registry value. |
|
MMMM |
The month is displayed as specified by the LOCALE_SMONTHNAME registry value.
|
|
y |
The year is displayed as the last digit. |
|
yy |
The year is displayed as the last two digits.
|
|
yyyy |
The year is displayed as four digits.
|
|
h |
The hour is displayed with no leading zero for single-digit hours (12-hour time format). |
|
hh |
The hour is displayed with a leading zero for single-digit hours (12-hour time format). |
|
H |
The hour is displayed with no leading zero for single-digit hours (24-hour time format). |
|
HH |
The hour is displayed with a leading zero for single-digit hours (24-hour time format). |
|
m |
The minute is displayed with no leading zero for single-digit minutes. |
|
mm |
The minute is displayed with a leading zero for single-digit minutes. |
|
s |
The second is displayed with no leading zero for single-digit seconds. |
|
ss |
The second is displayed with a leading zero for single-digit seconds. |
|
t |
AM/PM is represented as one character (A or P). |
|
tt |
AM/PM is represented as two characters. |