Membre

## Calculation field for time between

Résolue

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 Solution acceptée
Solution
Leader d'opinion | Partenaire solutions Platinum

## Calculation field for time between

Résolue

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 | Platinum Accredited PartnerHubSpot Expert, Top Community Champion | Hall of Fame IN23 Certified Trainer (12+ years) | SuperAdmins Bootcamp InstructorHave questions? Get answers:Get Premium Support

 Did my post help answer your question? Mark this as a solution.
2 Réponses
Solution
Leader d'opinion | Partenaire solutions Platinum

## Calculation field for time between

Résolue

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 | Platinum Accredited PartnerHubSpot Expert, Top Community Champion | Hall of Fame IN23 Certified Trainer (12+ years) | SuperAdmins Bootcamp InstructorHave questions? Get answers:Get Premium Support

 Did my post help answer your question? Mark this as a solution.
Au panthéon de la communauté | Partenaire solutions

## Calculation field for time between

Résolue

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.