# Calculation Property Limitations (and bug) **URL:** \ **Category:** HubSpot Ideas\ **Tags:** properties\ **Created:** [December 7, 2023, 3:49pm UTC](https://community.hubspot.com/t/calculation-property-limitations-and-bug/95611 "2023-12-07T15:49:32Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![anonymoose](https://avatars.discourse-cdn.com/v4/letter/a/a9adbd/32.png) [@anonymoose](https://community.hubspot.com/u/anonymoose)\ **Post date:** [December 7, 2023, 3:49pm UTC](https://community.hubspot.com/t/calculation-property-limitations-and-bug/95611/1 "2023-12-07T15:49:32Z")
Currently, calculate properties cannot add to or subtract when one of the values is a date property. It would be great if this would be possible. For example, if property A is a date property with 01/01/2023 as the date, I want the calculate property to add 12 months and give me the result of 01/01/2024. Calculate properties also allow you to divide a number (currency property) by a duration property (calculate property). When testing the formula in the create property dialogue, it looks like it works. However, in reality, it does not. If you look at the property in a record, it will always return a value that is between 0 and 1. This needs to be fixed. ---
**Author:** ![MariusTungesvik](https://avatars.discourse-cdn.com/v4/letter/m/b5e925/32.png) [@MariusTungesvik](https://community.hubspot.com/u/MariusTungesvik)\ **Post date:** [December 7, 2023, 3:59pm UTC](https://community.hubspot.com/t/calculation-property-limitations-and-bug/95611/2 "2023-12-07T15:59:03Z")
Was just about to submit a similar post. This should be added! ---
**Author:** ![SteveHTM](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/stevehtm/32/22074_2.png) [@SteveHTM](https://community.hubspot.com/u/SteveHTM)\ **Post date:** [December 8, 2023, 12:23am UTC](https://community.hubspot.com/t/calculation-property-limitations-and-bug/95611/3 "2023-12-08T00:23:00Z")
I’m not sure if this really an answer to your feature request, but calculated properties are much richer in recent versions than they used to be. For example, you can constrain the output type to be of different types now - and yes, you can add a fixed number to a date to get an offset date. See screenshot. ![Screen Shot 2023-12-07 at 4.13.51 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/b/3b4eecc7882ed19670644b5487f395e0abc16d68.png) You do have to factor in the underlying time value model in HubSpot - 1000 ticks a sec that is. And figure out leap-years etc. ---
**Author:** ![anonymoose](https://avatars.discourse-cdn.com/v4/letter/a/a9adbd/32.png) [@anonymoose](https://community.hubspot.com/u/anonymoose)\ **Post date:** [December 8, 2023, 1:14am UTC](https://community.hubspot.com/t/calculation-property-limitations-and-bug/95611/4 "2023-12-08T01:14:03Z")
Hi @SteveHTM This does answer my question when it comes to adding/subtracting fixed numbers from dates. Thank you! Would you mind explaining what the different numbers stand for in the equation - (24\*3600\*1000\*365)? ---
**Author:** ![SteveHTM](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/stevehtm/32/22074_2.png) [@SteveHTM](https://community.hubspot.com/u/SteveHTM)\ **Post date:** [December 8, 2023, 1:37am UTC](https://community.hubspot.com/t/calculation-property-limitations-and-bug/95611/5 "2023-12-08T01:37:34Z")
24 hrs 3600 seconds in an hr 1000 ticks in a second 365 days in (most) years ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [December 10, 2023, 11:31am UTC](https://community.hubspot.com/t/calculation-property-limitations-and-bug/95611/6 "2023-12-10T11:31:21Z")
I appreciate your response and it clarifies my understanding of manipulating dates with fixed numbers. Thank you Could you provide more insight into the specific values represented by the numbers in the equation (24_3600_1000\*365) I am eager to understand the components better.