topic Re: Get number of days between createdate & closedate of a deal in APIs & Integrations

Get number of days between createdate & closedate of a deal

S_Tasneem — Thu, 08 Sep 2022 06:46:35 GMT

Hello,

My requirement is to get the number of days-difference between cretedate & closedate of a deal. The number of days between these two dates should be populated in a third-party application form, So I am doing the development in a deal-based workflow. But I am not able to get the correct date format of the two dates, So I am not able to get the days-difference.

Try1: I have passed this line of code in workflow:

var create_date = event.inputFields['createdate']

but the value returned is

Try2: I tried changing the code to:

var create_date = new Date(event.inputFields['createdate'])

but the value returned is

Any suggestions would be greatly helpful.

Thankyou!

Re: Get number of days between createdate & closedate of a deal

Jaycee_Lewis — Mon, 12 Sep 2022 17:32:43 GMT

Hi, @S_Tasneem 👋 Let's see if we can get the converstaion going with some of our community experts.

Hey @Teun @LMeert @mangelet, do you have any insight you can offer to @S_Tasneem?

Thank you! — Jaycee

Re: Get number of days between createdate & closedate of a deal

LMeert — Tue, 13 Sep 2022 08:28:43 GMT

Hi @S_Tasneem,

On the first try you do get a timestamp, you simply have to substract both timestamps (create date - today or vice versa) and convert the result back in days.

A timestamp is usually in milliseconds, so to get the number of days you could use this simple formula :

result_in_days = result_in_ms/1000/60/60/24 and truncate that to the day.

Here's a working snippet I've just tested :

var date = event.inputFields['createdate']; var future_date = Date.now(); var days_difference = Math.abs(Math.trunc((future_date - date)/(1000*3600*24)));

Hope this helps !
If it does, please consider marking this answer as a solution 🙂

Best,

Ludwig

Re: Get number of days between createdate & closedate of a deal

Thrive — Wed, 24 Jul 2024 00:41:03 GMT

Hi there, we have built an app for the marketplace that allows you to automatically calculate the time between 2 dates. Feel free to check it out here: https://ecosystem.hubspot.com/marketplace/apps/marketing/data-management/calculations-3449553