Calculation field for time between

Smart CRM & Sales Hub CRM
1

I have a bit of dilemna and was hoping it could be solved by a workflow or custom formula( the ones I’ve tried seem to not work). I’m trying to add a duration field ( In months example: 6 months) to a start date field which is in date format( 2/1/2024). IN the calculated property i created I used this formula: [properties.expected_project_start_date]+ ([properties.duration]/12*365) = End date(In date format)

however I just get the project start date and not getting the desired date. Any help would be appreciated if this is even possible

2

Hi @CClark3,

HubSpot measures time in milliseconds, not days - can you try adjusting your formula accordingly?

3

Hey @CClark3

in this article you can have some more insight about how to Calculate values based on time between two properties.

You can see the explanations about milliseconds that Karsten Mentioned.

hope this helps