Design Workflows Builder Toolbox

To format the date, do the following:

  1. Go to the step configuration, and pick a date data reference using the braces icon.
  2. Click the Cog icon.
  1. Pick a format and click Save.
  2. The format you selected will show next to the reference. To remove the format, click the cog icon again and click Remove formatting. If you remove formatting, the date format will go back to the default.

When you add another data reference, you need to pick its date format separately. You can pick the same format or a different one.

​
Available date formats

Each data reference can have its own format. Refer to the table below to understand what each format contains. As you select the format for the date, you can see the preview of what the data will look like in the Preview field.

DirectiveMeaningExample
%aWeekday as locale’s abbreviated name.Sun, Mon, …, Sat (en_US);So, Mo, …, Sa (de_DE)
%AWeekday as locale’s full name.Sunday, Monday, …, Saturday (en_US);Sonntag, Montag, …, Samstag (de_DE)
%wWeekday as a decimal number, where 0 is Sunday and 6 is Saturday.0, 1, …, 6
%dDay of the month as a zero-padded decimal number.01, 02, …, 31
%bMonth as locale’s abbreviated name.Jan, Feb, …, Dec (en_US);Jan, Feb, …, Dez (de_DE)
%BMonth as locale’s full name.January, February, …, December (en_US);Januar, Februar, …, Dezember (de_DE)
%mMonth as a zero-padded decimal number.01, 02, …, 12
%yYear without century as a zero-padded decimal number.00, 01, …, 99
%YYear with century as a decimal number.0001, 0002, …, 2013, 2014, …, 9998, 9999
%HHour (24-hour clock) as a zero-padded decimal number.00, 01, …, 23
%IHour (12-hour clock) as a zero-padded decimal number.01, 02, …, 12
%pLocale’s equivalent of either AM or PM.AM, PM (en_US);am, pm (de_DE)
%MMinute as a zero-padded decimal number.00, 01, …, 59
%SSecond as a zero-padded decimal number.00, 01, …, 59
%fMicrosecond as a decimal number, zero-padded on the left.000000, 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 number.001, 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 0.00, 01, …, 53
%VWeek number of the year starting from 01 instead of 00.01, 02, …54
%cLocale’s appropriate date and time representation.Tue Aug 16 21:30:00 1988 (en_US);Di 16 Aug 21:30:00 1988 (de_DE)
%xLocale’s appropriate date representation.08/16/88 (None);08/16/1988 (en_US);16.08.1988 (de_DE)
%XLocale’s appropriate time representation.21:30:00 (en_US);21:30:00 (de_DE)
%%A literal ’%’ character.%