Loading
Help

Compare dates and times in Zaps

Last updated:

You can use Formatter to compare how much time has elapsed between a start and end date/time.


1. Add a Formatter step to your Zap

  • In the Zap editor, click the Action step, or click the plus + icon to add an action to your Zap.
  • Select Format.
  • Click the Action Event dropdown menu and select Date/Time.
  • Click Continue.

2. Customize the compare dates transformation

  • In the Set up action section, click the Transform dropdown menu and select Compare Dates.
  • In the Values section, click the Start Date field and select a date field from a previous step.
  • In the Separator field, enter the symbol or text that separates each value in your list. If nothing is entered, the Zap will use a comma by default.
  • Click Continue.
Note

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

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

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


3. Test your compare dates transformation

  • Click Test & Review. If the transformation is successful, the date comparison will be shown.
Tip

The Dates Swapped output 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 Same Dates output field only compares dates, not times. It is:

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

Need More Help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community

Zapier University

Video courses designed to help you become a better Zapier user, whether you’re a beginner or more experienced.
View courses