Modify date and time formats in Zaps

Formatter: Dates & Times

You can use Formatter’s Date/Time transform to change dates and times in your Zap. The Date/Time transform can reformat dates and times or add/subtract time from existing date/time data.

actionEdit icon Example

If you have an app that formats dates as MM/DD/YYYY but you need to send it to an app that formats dates as DD/MM/YYYY, you can use the Date/Time transform to change the date format.

1. Add a Formatter step

  • In the Zap editor, click the Action step, or click the plus + icon to add a step to your Zap.
  • Select Format.
  • Click the Event dropdown menu and select Date/Time.
  • Click Continue.
  • In the Set up action section, click the Transform dropdown menu and select the transform you want to use.
  • In the Values section, click the Input field and enter the data that you want to transform. You can choose a field from a previous step or enter a value.
miscEye icon Note

Some Date/Time transforms will have additional required or optional fields.

2. Customize your date and time options

Modify date and time formats in Zaps
Adding a new option: o - for ordinal day of the month (1st, 20th, etc.)

You can represent dates and times by combining variables in the following table:

Date/Time custom value table

Token Output
Year YYYY 2000, 2001, 2002 ... 2012, 2013
YY 00, 01, 02 ... 12, 13
Month MMMM January, February, March ...
MMM Jan, Feb, Mar ...
MM 01, 02, 03 ... 11, 12
M 1, 2, 3 ... 11, 12
Day of Year DDDD 001, 002, 003 ... 364, 365
DDD 1, 2, 3 ... 364, 365
Day of Month DD 01, 02, 03 ... 30, 31
D 1, 2, 3 ... 30, 31
Do 1st, 2nd, 3rd ... 30th, 31st
Day of Week dddd Monday, Tuesday, Wednesday ...
ddd Mon, Tue, Wed ...
d 1, 2, 3 ... 6, 7
Hour HH 00, 01, 02 ... 23, 24
H 0, 1, 2 ... 23, 24
hh 01, 02, 03 ... 11, 12
h 1, 2, 3 ... 11, 12
AM / PM A AM, PM
a am, pm
Minute mm 00, 01, 02 ... 58, 59
m 0, 1, 2 ... 58, 59
Second ss 00, 01, 02 ... 58, 59
s 0, 1, 2 ... 58, 59
Sub-second SSS 000, 001, 002 ... 998, 999
SS 00, 01, 02 ... 98, 99
S 0, 1, 2 ... 8, 9
Timezone ZZ -07:00, -06:00 ... +06:00, +07:00
Z -0700, -0600 ... +0600, +0700
Timestamp X 1381685817

3. Test your Date/Time transform

  • Click Test & Review.
  • If the test was successful, you'll see the results of the Date/Time transform.

Once you've set up the Formatter Date/Time transform, you can use the results in further actions in your Zap.

Was this article helpful?
4 out of 10 found this helpful