Skip to main content

Masks

The following table lists the mask attributes available when performing date and time mainpulation within Rules Engine, Workflow and Integrations.

Common Examples​

# Mask          # Format        # Result        # Comments
%Y-%m-%d        yyyy-mm-dd      2022-03-01      The system default
%y-%m-%d        yy-mm-dd        22-03-01        Two digit year
%m/%d/%Y        mm/dd/yyyy      03/01/2022      Classic
%m/%d/%y        mm/dd/yy        03/01/20        Two digit classic
%b %d, %Y       mmm dd, yyyy    Mar 01, 2022    Long form
%H:%M           hh:mm           14:37           24hr international
%I:%M %p        hh:mm am/pm     02:37 pm        12hr friendly

Complete List​

MaskMeaningExample
%aWeekday as locale’s abbreviated nameSun, Mon, …, Sat (en_US)
%AWeekday as locale’s full nameSunday, Monday, …, Saturday (en_US)
%wWeekday as a decimal number, where 0 is Sunday and 6 is Saturday0, 1, …, 6
%dDay of the month as a zero-padded decimal number01, 02, …, 31
%bMonth as locale’s abbreviated nameJan, Feb, …, Dec (en_US)
%BMonth as locale’s full nameJanuary, February, …, December (en_US)
%mMonth as a zero-padded decimal number01, 02, …, 12
%yYear without century as a zero-padded decimal number00, 01, …, 99
%YYear with century as a decimal number0001, 0002, …, 2013, 2014, …, 9998, 9999
%HHour (24-hour clock) as a zero-padded decimal number00, 01, …, 23
%IHour (12-hour clock) as a zero-padded decimal number01, 02, …, 12
%pLocale’s equivalent of either AM or PMAM, PM (en_US)
%MMinute as a zero-padded decimal number00, 01, …, 59
%SSecond as a zero-padded decimal number00, 01, …, 59
%fMicrosecond as a decimal number, zero-padded to 6 digits000000, 000001, …, 999999
%zUTC offset in the form ±HHMM[SS[.ffffff]] (empty string if the object is naive)(empty), +0000, -0400, +1030, +063415, -030712.345216
%ZTime zone name (empty string if the object is naive)(empty), UTC, GMT
%jDay of the year as a zero-padded decimal number001, 002, …, 366
%UWeek number of the year (Sunday as the first day of the week) as a zero-padded decimal number. All days in a new year preceding the first Sunday are considered to be in week 000, 01, …, 53
%WWeek number of the year (Monday as the first day of the week) as a zero-padded decimal number. All days in a new year preceding the first Monday are considered to be in week 000, 01, …, 53
%cLocale’s appropriate date and time representationTue Aug 16 21:30:00 1988 (en_US)
%xLocale’s appropriate date representation08/16/1988 (en_US)
%XLocale’s appropriate time representation21:30:00 (en_US)
%%A literal '%' character%