web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... DiffInDays value showi...

Customer experience | Sales, Customer Insights,...

Suggested Answer

DiffInDays value showing as hours instead of days

(0) Share

Report

Report

Posted on by jdalske

547

I am attempting to calculate the difference between two dates. The formula is correct as far as I can tell and I don't receive any errors. However, the field value displays in hours instead of days.

I tried to change it to weeks to see if that tricks the system to display days but it says minutes (even worse). The number appears to be accurate (with the exception of hours but it I multiple that by 60??) but the label is wrong. If I change it to a decimal number I get the correct results however, that doesn't make sense.

I would really like to be able to use the appropriate function and have it working properly.

Any help will be greatly appreciated!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

jdalske 547 on at

Like (0)

Report
Copy link

Link copied!

So it appears that if I use the data type text or decimal number, I get the correct results. I do not understand why the data type whole number displays a decimal and a label of hours or minutes when the formula I used is DiffInDays.

In summation, use the data type text with this calculated field.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

ManoVerse 196 Super User 2026 Season 1

#2

CU11031447-0 100

#3

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans