Date formatting uses the d3 time format. 

You can use the following rules in your formula:

shortcutdescription
%aabbreviated weekday name
%Afull weekday name
%babbreviated month name
%Bfull month name
%cdate and time, as %a %b %e %H %M %S %Y
%dzero-padded day of the month as a decimal number [01,31]
%espace-padded day of the month as a decimal number [ 1,31], equivalent to %d
%Hhour (24h - clock) as a decimal number [00,23]
%Ihour (12h - clock) as a decimal number [01,12]
%jday of the year as a decimal number [001,366]
%mmonth as a decimal number [01,12]
%Mminute as a decimal number [00,59]
%Lmilliseconds as a decimal number [000,999]
%peither AM or PM
%Ssecond as a decimal number [00,61]
%Uweek number of the year as a decimal number [00,53] (Sunday as the first day of the week)
%wweekday as a decimal number [0,6] (Sunday as the first day of the week)
%Wweek number of the year as a decimal number [00,53] (Monday as the first day of the week)
%xdate, as "%m%d%Y"
%Xtime as %H%M%S
%yyear without century as a decimal number [00,99]
%Yyear with century as a decimal number
%Ztime zone offset, such as"-0700"
%%a literal % character
  • No labels