# Why is the "Time Between" Calculation Fuzzy? **URL:** \ **Category:** CRM\ **Tags:** enterprise\ **Created:** [September 16, 2022, 9:29am UTC](https://community.hubspot.com/t/why-is-the-time-between-calculation-fuzzy/65249 "2022-09-16T09:29:38Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![eliot\_martin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/eliot_martin/32/62260_2.png) [@eliot\_martin](https://community.hubspot.com/u/eliot_martin)\ **Post date:** [September 16, 2022, 9:29am UTC](https://community.hubspot.com/t/why-is-the-time-between-calculation-fuzzy/65249/1 "2022-09-16T09:29:38Z")
If you use the “Time Between” Calculated property type on a Equation field type why on earth is the output fuzzy? Returning the string “_a month_” rather than an integer is nonsensical. Why go to the extra developmental effort of parsing what would have initially been a numerical value into something vague and fundamentally useless? Am I missing something or is there an actual numerical value hidden under the abstract output? _Edit_: To answer my own question, after some testing it appears that there is a numeric value under this fuzzy output. If I run a calculation on this value against an actual date property it returns milliseconds. ---
**Author:** ![SNigam](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/snigam/32/24290_2.png) [@SNigam](https://community.hubspot.com/u/SNigam)\ **Post date:** [September 18, 2022, 9:59am UTC](https://community.hubspot.com/t/why-is-the-time-between-calculation-fuzzy/65249/2 "2022-09-18T09:59:10Z")
Hello [@eliot\_martin](https://community.hubspot.com/t5/user/viewprofilepage/user-id/366725) , I got the issue. Yes you are right there is a numerical number behind string and if you use it in equation like if you try to do any calculation it will give output in miliseconds. Can you tell me what you are trying to do might be I can help you by any other method. Thank you Shubham Nigam HubSpot Administrator ---
**Author:** ![shayam](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/shayam/32/30597_2.png) [@shayam](https://community.hubspot.com/u/shayam)\ **Post date:** [November 22, 2022, 12:30am UTC](https://community.hubspot.com/t/why-is-the-time-between-calculation-fuzzy/65249/3 "2022-11-22T00:30:43Z")
I am having a very similar issue trying to calculate a value using a value returned bt the “time between” function. Can you help? ---
**Author:** ![kvlschaefer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kvlschaefer/32/71076_2.png) [@kvlschaefer](https://community.hubspot.com/u/kvlschaefer)\ **Post date:** [November 23, 2022, 1:35pm UTC](https://community.hubspot.com/t/why-is-the-time-between-calculation-fuzzy/65249/4 "2022-11-23T13:35:41Z")
Hi @shayam, Thanks for reaching out! May I ask if you can create a new post that includes details on the issue you are running into and any screenshots and examples of this issue? By creating a new post, this will ensure that your post gets visibility among our community members. Thank you! Best, Kristen ---
**Author:** ![chrisbrisson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chrisbrisson/32/78258_2.png) [@chrisbrisson](https://community.hubspot.com/u/chrisbrisson)\ **Post date:** [February 4, 2023, 6:33am UTC](https://community.hubspot.com/t/why-is-the-time-between-calculation-fuzzy/65249/5 "2023-02-04T06:33:51Z")
@SNigam The problem with this calculated field is that the Time Between is incorrect. It will show “days” as long as the range is 1 - 25 days. Then on day 26, it shows as “a month” which it isn’t a month. 30 or 31 days days is a month. This seems to be a bug. It would be great if it just showed the amount of DAYS and didn’t do this month, year, etc. It doesn’t really help and make things more complicated 😞 ![Screen Capture on 2023-02-04 at 01-30-59.gif](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/b/2bb7ed071699e8e973bd163200961c18ccb63192.gif) ---
**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\ **Post date:** [February 6, 2023, 9:37pm UTC](https://community.hubspot.com/t/why-is-the-time-between-calculation-fuzzy/65249/6 "2023-02-06T21:37:06Z")
Hi @chrisbrisson thanks for sharing 😊 Best, Diana