Time Format strings specify the format of the dynamic date/time label. The count of the ASCII letter pattern determines the format used.
ASCIISymbol | 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 | |
" (two single quotes) | Single Quote | Literal | ' |
When four or more Text type letters are used, the full form is provided.
When three or more Text & Number type 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.