Modify date and time formats in Zaps

Available on plans:

Free

Starter

Professional

Team

Company

Formatter: Dates & Times

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

This action offers you three transforms for dates and time:

  • Add/Subtract Time
  • Compare Dates
  • 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.

2. Select your transform

Add or subtract time Compare dates Format
Use this transform to add or subtract a date and time.
  • In the Set up action section, click the Transform dropdown menu and select Add/Subtract Time.
  • Click Continue.
  • In the Action section, click the Input field and enter the date and time that you want to transform. You can choose a field from a previous step or enter a value.
  • In the Expression field, add the amount of time you would like to either add or subject. This field accepts formats such as  +8 hours 1 minute+1 month -2 days-1 day +8 hours.
  • Click the To Format dropdown menu and select what format you would like for your date and time. 
  • (Optional) Click the From Format dropdown menu and select the date and time format that matches the data added to the Input field.
  • Click Continue.
Screenshot of Zap editor showing you an example of how to set up the Formatter action Add or Subtract transform.png

 

3. Test your action

  • Click Test step.
  • If the test was successful, you'll see the Date/Time action results.

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

 

Customize your date and time format options

If the date and time format isn't available in the relevant format dropdown menu, you use a custom value and set the format with tokens. 

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
 

 

Was this article helpful?
14 out of 92 found this helpful