# Trigger workflow when two dates are equal

**URL:** <https://community.hubspot.com/t/trigger-workflow-when-two-dates-are-equal/73815>\
**Category:** HubSpot Ideas\
**Tags:** workflows\
**Created:** [January 26, 2023, 12:52pm UTC](https://community.hubspot.com/t/trigger-workflow-when-two-dates-are-equal/73815 "2023-01-26T12:52:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![GFernandez34](https://avatars.discourse-cdn.com/v4/letter/g/3d9bf3/32.png) [@GFernandez34](https://community.hubspot.com/u/GFernandez34)\
**Post date:** [January 26, 2023, 12:52pm UTC](https://community.hubspot.com/t/trigger-workflow-when-two-dates-are-equal/73815/1 "2023-01-26T12:52:47Z")

</div>

It would be great to be able to trigger a workflow when two date properties are equal.

For example: when sign-up date = first order date, send a notification to the sales team.

---

<div class="post-metadata">

**Author:** ![05201](https://avatars.discourse-cdn.com/v4/letter/0/ccd318/32.png) [@05201](https://community.hubspot.com/u/05201)\
**Post date:** [July 24, 2023, 5:31pm UTC](https://community.hubspot.com/t/trigger-workflow-when-two-dates-are-equal/73815/2 "2023-07-24T17:31:42Z")

</div>

Yes Exactly, when Close date =Today Date, i need to complete a followup, but i dont find a way except gathering the data via report

---

<div class="post-metadata">

**Author:** ![Plue](https://avatars.discourse-cdn.com/v4/letter/p/ac91a4/32.png) [@Plue](https://community.hubspot.com/u/Plue)\
**Post date:** [November 2, 2023, 10:34am UTC](https://community.hubspot.com/t/trigger-workflow-when-two-dates-are-equal/73815/3 "2023-11-02T10:34:45Z")

</div>

A workaround that might work is to make a new calculation property with calculated property type time between, Number format: Duration.  
Start date pick the property 1 with a date and End date is property 2 with another date field.

So this new property will calculate the difference between these 2 dates and you can use this property in a workflow to trigger if the difference is more than 1 day for example. This solved the issue for me.

In the workflow, simply add a check to this property if its greater than 1 day.

---

<div class="post-metadata">

**Author:** ![JGombos](https://avatars.discourse-cdn.com/v4/letter/j/8baadc/32.png) [@JGombos](https://community.hubspot.com/u/JGombos)\
**Post date:** [April 26, 2024, 7:08pm UTC](https://community.hubspot.com/t/trigger-workflow-when-two-dates-are-equal/73815/4 "2024-04-26T19:08:33Z")

</div>

I like that option Plue! Here’s another idea I tried when I needed to compare 2 dates in a workflow to see if they matched up or not, and it seems to work well! Convenient if you happen to be checking different dates depending on pipeline or situation - or if one of the dates is in another object (haven’t tried that one yet, but see no reason why it wouldn’t work).

1. create a property in your object to get the result of the comparison (i.e. date check)
2. in the workflow use the format data option - custom mode
  1. put in a formula: number(unixtimestamp([property1]))-number(unixtimestamp([property2]))
  2. copy the result into your date check property
  3. branch: if date check=0, numbers are the same - if not, they are different