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

Compare dates and times 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. Set up your transform 3. Test your action

Available on plans:

A green checkmark

Free

A green checkmark

Pro

A green checkmark

Team

A green checkmark

Enterprise

Formatter’s Date/Time action allows you to calculate the time difference between two dates and time. You can compare the start and end dates to find the duration in days, hours, minutes, and seconds. 

You can use this to accomplish tasks such as:

  • Identifying overdue tasks or deadlines.
  • Booking systems availability check.
  • Service level agreement (SLA) monitoring.

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. Set up your transform

  • Click the Transform field dropdown menu and select Compare Dates.
  • In the Start Date field, manually enter the date/time or map the field from the previous step.
  • In the End Date field, manually enter the date/time or map the field from the previous step. 
  • (Optional) You can explicitly set the date and time format for your Start and End Date fields to ensure Zapier interprets it correctly. 
    • You can also set the date and time format using a custom value.
  • Click Continue to continue to the Test tab.
ratingStar icon Tip

To compare a date against today's date, enter {{zap_meta_human_now}} into the field. Learn more about using custom timestamps in Zaps.

miscEye icon Note

For the Start Date and End Date fields, Formatter will assume:

  • The date is today is no date is entered (only a time is entered).
  • The time is midnight if no time is entered (only a date is entered).

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 date comparison.

The Output Dates Swapped field is:

  • False if the end date/time is after the start date/time.
  • True if the end date/time is before the start date/time.

The Output Same Dates field only compares dates, not times. It is:

  • False if the date does not exactly match.
  • True if the date exactly matches.

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

ratingStar icon Tip

You can add a filter or paths to your Zap based on the date and time to set time-based conditions or branching logic.

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?
  • Modify date and time formats in Zaps

Copyright 2025 – OBZ-Zapier.

Knowledge Base Software powered by Helpjuice

Expand