News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to calculated dura...

Microsoft Dynamics CRM (Archived)

How to calculated duration of 2 field datetime follow days, weeks, months,....

(0) Share

Report

Report

Posted on by Son Dang

40

Hi everybody,

I have 2 field data time and field duration as images:

11174.Capture.PNG

4118.Capture1.PNG

2451.Capture3.PNG

How can I change "335 days" to about "48 weeks" of field duration?

I try to change diffinWeeks as image

6175.Capture4.PNG

but Duration is incorrect :(

4527.Capture5.PNG

Please help me resolve it.

Thanks a lot.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Son Dang 40 on at

Like (1)

Report

RE: How to calculated duration of 2 field datetime follow days, weeks, months,....

Yep, so you don't have any way to customize it.

I just want field duration have unit (weeks, months,...).

I'll use Whole Number with Format = None.

Thank Anees Faizal :)
Verified answer

Faizal 545 on at

Like (1)

Report

RE: How to calculated duration of 2 field datetime follow days, weeks, months,....

Hi Son Dang,

I would suggest you to use Whole Number (Format = None).

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,399 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans