Calculating Day difference Between Two Dates

(0) Share

Report

Posted on by Sunny21

Good Day. Thank you for your interest.

We have a simple requirement where we need to calculate the difference in Days between two dates. I used a duration field and the end result is shown in (minutes)? For example, 1/24/2022 -to- 1/27/2022 = 3 (minutes)? I just need to be able to show the Difference in Days as a Whole Number. Kindly share and let me know if further clarification is needed.

Then I created a Date and Time calculation field and the DiffinDays(Start Time, End Time) calculation results in error.

"You can't set the value DiffInDays(crbdd_leavestarttime, crbdd_leaveendtime), which is of type integer, to type dateTime."

Best Regards, Sunny

Date-Difference-Calculation.PNG_2D00_928x656.png

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

RE: Calculating Day difference Between Two Dates

Hi Sunny21,

Yes, you need to create a calculated field. However, it's type should be whole number not Data and Time because DiffInDays() function's return type is whole number.

Please refer to this doc:

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calculated-fields?view=op-9-1#calculated-field-functions-syntax

Test:

I create a calculated field named Duration to calculate the difference in Start Time and End Time of Booking Journal entity.

Result:

Was this reply helpful? Yes No
Sunny21 90 on at

Like (0)

Report

Calculating the Date Difference between two columns

Good Day. Thank you for your interest.

We have a simple requirement where we need to calculate the difference in Days between two dates. I used a duration field and the end result is shown in (minutes)? For example, 1/24/2022 -to- 1/27/2022 = 3 (minutes)? I just need to be able to show the Difference in Days as a Whole Number. Kindly share and let me know if further clarification is needed.

Then I created a Date and Time calculation field and the DiffinDays(Start Time, End Time) calculation results in error.

"You can't set the value DiffInDays(crbdd_leavestarttime, crbdd_leaveendtime), which is of type integer, to type dateTime."

Best Regards, Sunny

Was this reply helpful? Yes No