Support Portal

Welcome
Login

Time Formatting for Charts

Time values in Analytics charts can be formatted using the following syntax. Note that these elements can be strung together to create specific formats of your choosing.

Format TypeDescriptionUse This Expression
Time
TimeMilliseconds as a decimal number, i.e. 000 to 999%L
TimeSecond as a two-digit number, i.e. 00 to 59%S
TimeMinute as a two-digit number, i.e. 00 to 59%M
TimeHour as a decimal number (24-hour clock), i.e. 00 to 23%H
TimeHour as a decimal number (12-hour clock), i.e. 01 to 12%I
TimeEither AM or PM%p
Date
DateDay of the year as a decimal number, i.e. 001 to 366%j
DateZero-padded day of the month, i.e. 01 to 31%d
DateSpace-padded day of the month (equivalent to %_d), i.e. 1 to 31%e
DateFull weekday name, i.e. Monday, Tuesday, Wednesday%A
DateAbbreviated weekday name (3-letter), i.e. Mon, Tue, Wed%a
DateWeekday as a decimal number (Sunday as the first day of the week), i.e. 0 to 6%w
Week
WeekWeek number of the year (Sunday as the first day of the week) as a two-digit number, i.e. 00 to 53%U
WeekWeek number of the year (Monday as the first day of the week) as a two-digit number, i.e. 00 to 53%W
Month
MonthTwo-digit month, i.e. 01 through 12 (1-12 format not currently available)%m
MonthAbbreviated month name, i.e. Jan, Feb, Mar%b
MonthFull month name, i.e. January, February, March%B
Year
YearTwo-digit year, i.e. 00 to 99%y
YearFour-digit year, i.e. 2000, 2001, 2002%Y
Combination
CombinationFull time, of the form “%H:%M:%S”, i.e. 23:56:12%X
CombinationFull date, of the form “%m/%d/%Y”, i.e. 01/27/2014%x
CombinationDatetime format with the following: “%a %b %e %H:%M:%S %Y”, i.e. Mon Jan 1 23:56:04 2014%c
Other
OtherTime zone offset, i.e. “-0700” for PST from GMT%Z

Notes: For %U, all days in a new year preceding the first Sunday are considered to be in week 0. For %W, all days in a new year preceding the first Monday are considered to be in week 0.

Padding: The % sign in the examples above may be followed by one of these padding modifiers:

  • 0 zero-padding
  • _ space-padding
  • - disable padding

If no padding modifier is used, the default is 0 for all formats (except for %e which defaults to _).