Skip to content
Contact us
  • There are no suggestions because the search field is empty.

How to use Date Difference in Property Transformer

The Date Difference action lets you calculate the difference between two dates in your chosen unit. This is useful for calculating days since last activity, time to close a deal, customer lifetime, or any other duration between two dates.

This action works on all object types including Contacts, Companies, Deals, and Custom Objects.

Supported property types:
- Date picker

How to set it up

  • In your HubSpot workflow, add a new action

  • Under "Integrated Apps", find "Brave Tools"

  • Select "Date Difference"

  • Configure the input fields (see below)

  • Map the output values to the properties you want to update

Input fields

Start date (required)
The start date property. Select any date picker property from the enrolled object.

End date
The end date property. Leave this empty to use today's date, which is useful for calculating "days since" values that stay up to date.

Output unit
The unit for the result. Options: Minutes, Hours, Days, Weeks, Months, Years. Defaults to Days.

Rounding
How to round the result. Options:
- Round (default) - Standard rounding
- Round down - Always round down
- Round up - Always round up
- No rounding (2 decimals) - Keep two decimal places

Output fields

Difference - The numeric difference between the two dates.
Difference label - The numeric difference as a text string.

Example

You want to calculate how many days a deal has been open.

Configuration: Output unit = Days, Rounding = Round
Input: Start date = 2026-01-01, End date = 2026-02-17
Output: Difference = 47, Difference label = "47"

Good to know

  • If you leave the End date empty, it will automatically use today's date. This means the value updates every time the workflow runs.

  • The Difference output is a number, useful for calculations or branching logic. The Difference label is the same value as text, useful for storing in a text property.

  • If the start date is empty, the output fields will be left empty and the workflow will continue.

  • Property Transformer is available on paid plans. Trial users do not have access to this feature.