Available on plans:
Free
Pro
Team
Enterprise
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
Use this transform to add or subtract a date and time.
- In the Action tab, click the Transform dropdown menu and select Add/Subtract Time.
- New fields will populate below the Transform field.
- In the Values 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.
Use this transform to calculate the difference duration between two dates and times.
- In the Action tab, click the Transform dropdown menu and select Add/Subtract Time.
- New fields will populate below the Transform field.
- In the Values section, click the Start Date field and enter the date and time you want to compare. You can choose a field from a previous step or enter a value.
- In the End Data Value field, add the date you want to compare with your start date. You can choose a field from a previous step or enter a value.
- (Optional) Click the Date Format - Start Date dropdown menu and select the start date format.
- (Optional) Click the Date Format - End Date dropdown menu and select the end date format.
- Click Continue.
Use this transform to format your date and time into a particular format.
- In the Action tab, click the Transform dropdown menu and select Add/Subtract Time.
- New fields will populate below the Transform field.
- In the Values section, click the Input field and enter the date and time you want to compare. You can choose a field from a previous step or enter a value.
- Click the To Format dropdown menu and select what format you would like for your date and time.
- Click the To Timezone dropdown menu and select the timezone your date should be converted to.
- (Optional) Click the From Format dropdown menu and select the date and time format that matches the data added to the Input field.
- Click the From Timezone dropdown menu and select the timezone your Indate should be converted to.
- Click Continue.
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 |