Calculated Duration Field

(0) Share

Report

Posted on by Community Member

I have a custom entity that has a start and end date and I have created a calculated field to show the duration. However I have setup the formula with DiffinInMonths, but when on the record is showing up as minutes. I suspect that CRM is reading the "m" as lower case and automatically showing up as minutes, but I can't find a way to fix this.

Does anyone have an idea on how to fix this?

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

Community Member on at

Like (0)

Report

RE: Calculated Duration Field

Hey Lucas,

This does indeed appear to be a bug, but if you just need the number without creating any JavaScript, do the following:

-create a new calculated field

-select 'None' under formatting, instead of 'Duration'

Hope this helps.
Verified answer

Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

RE: Calculated Duration Field

Hi

It looks like a Bug.

Instead of Days it says Minutes

Please use JavaScript instead of Calculated field.

mscrmtechie.blogspot.co.uk/.../get-difference-between-two-dates-in.html