CRM

CClark3
Participant

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
Lucila-Andimol
Solution
Thought Leader | Platinum Partner
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 | Platinum Accredited Partner
HubSpot Expert, Top Community Champion | Hall of Fame IN23&IN24
Certified Trainer (12+ years) | SuperAdmins Bootcamp Instructor

Have questions? Get answers:

Get Premium Support

Did my post help answer your question? Mark this as a solution.

View solution in original post

0 Upvotes
2 Replies 2
Lucila-Andimol
Solution
Thought Leader | Platinum Partner
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 | Platinum Accredited Partner
HubSpot Expert, Top Community Champion | Hall of Fame IN23&IN24
Certified Trainer (12+ years) | SuperAdmins Bootcamp Instructor

Have questions? Get answers:

Get Premium Support

Did my post help answer your question? Mark this as a solution.

0 Upvotes
karstenkoehler
Hall of Famer | Partner
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öhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

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

0 Upvotes