Date and Time Formats

You are here:

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 \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

Table of Contents