Date and Time Formats
Custom formats may be applied to the Series Format, Category Format, and Value Format fields when designing reports. The following table lists commonly-used formats for displaying dates. In the example column, we will use the date of June 1, 2020 at 1:04:59 PM to display various formats. Please note that capitalization matters for the date format.
Date/Time Format Specifier | Description | Example |
d | The day of the month, from 1 through 31 (no leading zeroes). | M-d-yyyy → 6-1-2020 |
dd | The day of the month, from 01 through 31. | M-dd-yyyy → 6-01-2020 |
ddd | The abbreviated name of the day of the week (three letters). For best results, please limit the date range of your results to the last week, or less. | ddd → Mon |
dddd | The full name of the day of the week. For best results, please limit the date range of your results to the last week, or less. | dddd → Monday |
M | The number of the month, from 1 through 12 (no leading zeroes). | M-d-yyyy → 6-1-2020 |
MM | The number of the month, from 01 through 12. | MM-d-yyyy → 06-1-2020 |
MMM | The abbreviated name of the month (three letters). | MMM-d-yyyy → Jun-1-2020 |
MMMM | The full name of the month. | MMMM-d-yyyy → June-1-2020 |
yy | The last two digits of the year, from 00 to 99. | M-d-yy → 6-1-20 |
yyyy | The full four digits of the year. | M-d-yyyy → 6-1-2020 |
h | The hour, using a 12-hour clock from 1 to 12 (no leading zeroes). | h:mm:ss → 1:04:59 |
hh | The hour, using a 12-hour clock from 01 to 12. | hh:mm:ss → 01:04:59 |
H | The hour, using a 24-hour clock from 0 to 23 (no leading zeroes). | H:mm:ss → 13:04:59 |
HH | The hour, using a 24-hour clock from 00 to 23. | HH:mm:ss → 13:04:59 |
m | The minute, from 0 through 59 (no leading zeroes). | h:m:ss → 1:4:59 |
mm | The minute, from 00 through 59. | h:mm:ss → 1:04:59 |
s | The second, from 0 through 59 (no leading zeroes). | h:mm:s → 1:04:59 |
ss | The second, from 00 through 59. | h:mm:ss → 1:04:59 |
t | The first character of the AM/PM designator. | h:mm:ss t → 1:04:59 P |
tt | The AM/PM designator. | h:mm:ss tt → 1:04:59 PM |
: | The time separator, which translates over exactly as shown. | h:mm:ss → 1:04:59 |
/ | A date separator, which translates over exactly as shown. | M/dd/yyyy → 6/01/2020 |
\ | The escape character, which creates a space in the string. | ss \s → 59 s |
“text string” ‘text string’ | Text strings may be inserted. They must include double or single quotes on either end of the text string. | ss “seconds” → 59 seconds |