# Custom Deal Property **URL:** \ **Category:** CRM\ **Tags:** crm\ **Created:** [March 5, 2024, 10:22pm UTC](https://community.hubspot.com/t/custom-deal-property/101791 "2024-03-05T22:22:17Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![DDeter](https://avatars.discourse-cdn.com/v4/letter/d/ccd318/32.png) [@DDeter](https://community.hubspot.com/u/DDeter)\ **Post date:** [March 5, 2024, 10:22pm UTC](https://community.hubspot.com/t/custom-deal-property/101791/1 "2024-03-05T22:22:17Z")
Hi everyone, My first post here! I have a quota software that looks at HubSpot Deal Objects. I need a property that looks at a company field or the FIRST deal to calculate the total duration the company has been a “customer.” When I choose the custom equations, I can’t find a way to calculate them. I appreciate any help! ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [March 6, 2024, 5:21am UTC](https://community.hubspot.com/t/custom-deal-property/101791/2 "2024-03-06T05:21:57Z")
Hi @DDeter, Since you want to calculate a duration here, today’s date is needed - and unfortunately that’s not something HubSpot offers out of the box. If you have Operations Hub Professional, this is best set up with a daily recurring workflow that sets a “Today’s date” property to the current date. If you don’t have Operations Hub Professional, here is a workaround: [https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/Setting-Today-s-Date-with-Workflows/m-p/883062#M7076](https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/Setting-Today-s-Date-with-Workflows/m-p/883062#M7076) Once you have “Today’s date”, you can create a calculation property and for calculation type, you wouldn’t choose custom formula but “duration between”. You can then enter the company “Close date” property for the start date and the “Today’s date” for the end date. Let me know if you have any follow-up questions! ---
**Author:** ![DDeter](https://avatars.discourse-cdn.com/v4/letter/d/ccd318/32.png) [@DDeter](https://community.hubspot.com/u/DDeter)\ **Post date:** [March 6, 2024, 1:42pm UTC](https://community.hubspot.com/t/custom-deal-property/101791/3 "2024-03-06T13:42:56Z")
Thank you, Karsten - this is very helpful! ---
**Author:** ![Lucila-Andimol](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lucila-andimol/32/69276_2.png) [@Lucila-Andimol](https://community.hubspot.com/u/Lucila-Andimol)\ **Post date:** [March 6, 2024, 11:31am UTC](https://community.hubspot.com/t/custom-deal-property/101791/4 "2024-03-06T11:31:47Z")
Hey @DDeter so the main complication for the moment is as Karsten said having the "today"property set up to calculate the total duration the company has been a “customer.” You can always use Operations Hub or 3rd party tools like Zapier to create that timestamp for today specially if you are looking at this calculation frequently. BUT if you want something simpler to be updated/looked once in a while you can create a “Today” property that you update manually to the current date and then have your calculated property that makes the ecuation between "become a customer date"and your new "today"property. This could be another manual workaround. For the calculated property then you can set the time between this 2 properties like this: ![Screenshot 2024-03-06 at 12.31.35.png](https://d2qpr2jzcazej7.cloudfront.net/original/1X/4a5a09b098ab9d31db2a695d74975c8ff956a507.png) hope this helps ---
**Author:** ![DDeter](https://avatars.discourse-cdn.com/v4/letter/d/ccd318/32.png) [@DDeter](https://community.hubspot.com/u/DDeter)\ **Post date:** [March 6, 2024, 1:43pm UTC](https://community.hubspot.com/t/custom-deal-property/101791/5 "2024-03-06T13:43:36Z")
Thank you Lucila! This will definitely work if I can’t get it automated!