Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • Built-in tools
  • Formatter
  • Date/Time

Modify date and time formats in Zaps

Written by Owner

Updated at August 20th, 2025

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Tables
    Work with tables Manage tables Create tables Troubleshoot Zapier Tables
  • Product updates
    Product updates: January 2023 Product updates: March 2023 Product updates: February 2023 Product updates: April 2023 Product updates: May 2023 Product updates: June 2023 Product updates: July 2023 Product updates: August 2023 Product updates: September 2023 Product updates: October 2023 Product updates: November 2023 Product updates: December 2023 Product updates: January 2024 Product updates: February 2024 Product updates: March 2024 Product updates: April 2024 Product updates: May 2024 Product updates: June 2024 Product updates: July 2024 Product updates: August 2024 Product updates: September 2024 Product updates: October 2024 Product updates: November 2024 Product updates: December 2024 Product updates: January 2025 Product updates: February 2025 Product updates: March 2025 Product updates: April 2025 Product updates: May 2025 Product updates: June 2025 Product updates: July 2025 Product updates: August 2025
  • Zaps
    Zap basics Zap history Troubleshoot Zaps Manage your Zaps Do more with Zaps
  • Your Zapier account
    Plans Billing Account profile Notifications Data privacy & security Get help User roles and permissions
  • Interfaces
    Troubleshoot Zapier Interfaces Create an interface Use interface components Manage interfaces
  • Canvas
    Create a canvas Collaborate on a canvas
  • Chatbots
    Add logic and knowledge to chatbots Troubleshoot chatbots Create chatbots Manage chatbots
  • Getting started
    Intro to Zapier Set up your Zapier account Use case templates
  • Agents
    Create agents Manage agents Troubleshoot agents
  • MCP
    Set up MCP
  • Built-in tools
    Filter & Paths Formatter Schedule & Delay Email, IMAP, SMTP, & Email Parser Webhooks & Code Storage, Digest, & RSS Sub-Zap & Looping Other built-in tools Custom Actions & API Requests Functions AI by Zapier & AI actions Copilot Human in the Loop
  • Lead Router
    Create routers
  • Apps
    Connect and manage your app connections AI apps on Zapier Apps on Zapier
+ More

Table of Contents

1. Add a Formatter step 2. Select your transform 3. Test your action Customize your date and time format options Date and time custom value table

Available on plans:

A green checkmark

Free

A green checkmark

Pro

A green checkmark

Team

A green checkmark

Enterprise

Use Formatter to format and style dates and times. This is essential for:

  • Ensuring data compatibility: Different apps may require specific date formats.
  • Localizing dates and times: Adapt dates and times for different regions.

This is helpful when you need a different format in later steps in your Zap.

actionEdit icon Example

One app may send the data as 10/15/2024, while another might require October 15, 2024. Formatter allows you to convert between these formats.

Formatter: Dates & Times

1. Add a Formatter step

  • In the Zap outline, click the Action step or the plus sign + to add a new action. A dialog box will open.
  • In the search box, search for and select Formatter. The right sidebar will open to the Setup tab.
  • Click the Action event dropdown menu and select Date / Time.
  • Click Continue to continue to the Configure tab.

2. Select your transform

  • Click the Transform field dropdown menu and select Format.
  • In the Input field, map a field containing a date from the previous step.
  • In the To Format dropdown menu, select a pre-defined format option.
  • (Optional) In the To Timezone dropdown menu, select a timezone. The default is UTC.
  • (Optional) You can explicitly set the date and time format and timezone for your Input field to ensure Zapier interprets it correctly. 
    • If you do not complete the From Timezone field, it will assume it is UTC.
  • Click Continue to continue to the Test tab.
ratingStar icon Tip

If a date and time format is missing from the dropdown menu, you can customize the format using a custom value. 

3. Test your action

Test your action to verify it is calculating the difference between the date and time correctly.

  • Click Test step.
  • The Data out tab will display the new formatted date and time.
  • If the new date time is not what you expect, you can adjust the transform settings and retest the step again.

Once you’ve set up your Formatter action, you can use the results in further actions in your Zap.

Customize your date and time format options

If the date and time format you need is not available in the relevant dropdown menu, you set the format as a custom value using tokens. 

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

Date and 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?

Yes
No
Give feedback about this article

Related Articles

  • Add or subtract dates and times in Zaps
  • Can I use a date format that’s not in the list of formats?
  • Compare dates and times in Zaps

Copyright 2025 – OBZ-Zapier.

Knowledge Base Software powered by Helpjuice

Expand