Time Format strings specify the format of the dynamic date/time label. The number and order of ASCII characters determines the format used:
ASCII Symbol | Meaning | Type | Example |
|---|---|---|---|
G | Era | Text | AD |
y | Year | Number | 2002 |
M | Month in Year | Text & Number | July & 07 |
d | Day in Month | Number | 10 |
h | Hour in am/pm (1-12) | Number | 12 |
H | Hour in Day (0-23) | Number | 0 |
m | Minute in Hour | Number | 30 |
s | Second in Minute | Number | 55 |
S | Millisecond | Number | 978 |
E | Day in Week | Text | Tuesday |
D | Day in Year | Number | 189 |
F | Day of Week in Month | Number | 2 (meaning 2nd Wed in July) |
w | Week in Year | Number | 27 |
W | Week in Month | Number | 2 |
a | am/pm marker | Text | PM |
k | Hour in Day (1-24) | Number | 24 |
K | Hour in am/pm (0-11) | Number | 0 |
z | Time Zone | Text | Pacific Standard Time |
' (apostrophe) | Escape for Text | Delimiter | |
' ‘(single quote) | Single Quote | Literal | ' |
When four or more characters are used, a completely spelled value is returned.
When three or more Text & Number types letters are used, text is provided. When only one or two letters are provided for this type, the number is provided.
Numbers use the minimum number of digits. Year can be truncated to two digits. Shorter numbers are zero-padded.