Modulo function (remainder) in calculated field

(0) Share

Report

Posted on by Community Member

Hi,

This may have been asked before, but I can't find anything on it. I am trying to create a calculated field on a form that will come up with a time difference between two entered, date/time fields in Days and Hours. In T-SQL, I would use the Modulo ("%") function, but can't find anything like that for Dynamics CRM. Someone must have done this already, but I must be looking in the wrong places.

Any help is appreciated.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ivan Ficko 1,380 on at

Like (0)

Report

You will need to write some JavaScript or C# workflow step for such calculation, there is no way to do this by OOB CRM functionality.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I was kind of afraid of that and it is beyond my capabilities. I can't believe no one has had a Sales Manager who wanted to know how long it was between when an opportunity or Case is created and when it is resolved (won or lost). Thanks though, Ivan.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Although I have not done this, I think you should be able to do this with out of the box capabilities using some creative approach. For example, you can calculate the difference in hours (DIFFINHOURS), store it in a temp table using "create record" within the workflow, retrieve this value and divide the number by 24 and store the result in a whole number field in the temp table, then subtract this from the original number to get the hours, etc.

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Not sure if this is something you are ok with since you can use MOD or DIV in calculated fields, you are able to use DiffInDasys. Specify both dates and you will get the difference: DiffInDays(startdate, enddate)

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That is sure worth a try. Thanks!

Was this reply helpful? Yes No