web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Simple way to get year...

Power Apps

Answered

Simple way to get year(s), month(s), and day(s) between two dates?

(0) Share

Report

Report

Posted on by Cooper01

664

I have two values stored as dates. Given the example values 3/16/2020 and 3/17/2021, the value I'd like to show is 1 year(s) 0 month(s) 1 day(s).

I realize I could use the DateDiff and Mod functions and then subtraction to get this but is there a more elegant way to accomplish this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

Pstork1 69,543 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
I haven't seen a more refined way to do it than using Mod() Here are the formulas I use for Days, Hours, and Minutes in a component I built. You can easily extrapolate them to Years, Months, Days.

Days = RoundDown(DateDiff(Component1.StartDate,Component1.TargetDate,Minutes)/1440,0) Hours = Mod(DateDiff(Component1.StartDate,Component1.TargetDate,Hours),24) Minutes = Mod(DateDiff(Component1.StartDate,Component1.TargetDate,Minutes),60)

Was this reply helpful? Yes No
Pedexman 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Pstork1,

Can you share how you would get the Years, Month and Day please. I have been looking how to figure this out also.

Thanks

Was this reply helpful? Yes No
Pstork1 69,543 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Please post this as a new question. You'll get more responses and others will be able to find the answer more easily later. The code to get the Years, months, and days from a specific date is there in the answer. So I'm not sure what you are asking for.

Was this reply helpful? Yes No

Join the conversation