Member

Calculation field for time between

SOLVE

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

1 Accepted solution
Solution
Thought Leader | Platinum Partner

Calculation field for time between

SOLVE

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

 María Lucila Abal | COO Andimol | Accredited PartnerHubSpot Expert, Community Hall of Fame & Certified Trainer (12+ years)Have questions? Get answers:Get Premium Support

 Did my post help answer your question? Mark this as a solution.
2 Replies 2
Solution
Thought Leader | Platinum Partner

Calculation field for time between

SOLVE

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

 María Lucila Abal | COO Andimol | Accredited PartnerHubSpot Expert, Community Hall of Fame & Certified Trainer (12+ years)Have questions? Get answers:Get Premium Support

 Did my post help answer your question? Mark this as a solution.
Hall of Famer | Partner

Calculation field for time between

SOLVE

Hi @CClark3,

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

 Karsten KöhlerHubSpot Freelancer | RevOps & CRM Consultant | Community Hall of FamerBeratungstermin mit Karsten vereinbaren

 Did my post help answer your query? Help the community by marking it as a solution.