Answered

Date Calculation and Print to PDF

(0) Share

Report

Posted on by DataGuy85

Good Afternoon Community,

I have a challenge. I am doing a employment experience calculator. Testing my abilities in PowerApps. In the calculator I am trying to calculate the years, months and days difference for multiple period. Now figuring out the DateDiff in years, months and days is between the start and end days is easy. I did that but here is the scenerio.

Lets say I have a total of 1700 days. That is 4 years, 7 months and 21 days which I am able to replicate in excel using the DatedIf function. In PowerApps, I want that same result in txtTotalTimeElapsed which is highlighted below. I have tried taking the value of each periods DateDiff(input1,input2,Days) then divide it by 365 to get the years and by 30 days to get the months but the calculations are not adding up. I feel like a concat function would be the solution but I was wrong. Any help would be appreciated.

Side question, I am not using a form but I would like the user to be able to print the data as a PDF in a specific format.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @DataGuy85,

Try as below:

With( { totalDays: DateDiff( DatePicker2.SelectedDate,//statrt date DatePicker3.SelectedDate,//end date Days ) + 1 }, With( { totalYears: RoundDown( totalDays / 365, 0 ), remainingDaysFromYearsRollUp: Mod( totalDays, 365 ) }, With( { MonthsInRemainingDays: RoundDown( remainingDaysFromYearsRollUp / 30, 0 ), remainingDaysFromMonthsRollUp: Mod( remainingDaysFromYearsRollUp, 30 ) }, totalYears & " years / " & MonthsInRemainingDays & " months / " & remainingDaysFromMonthsRollUp & " days" ) ) )

Was this reply helpful? Yes No
DataGuy85 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you that fixed it.

Was this reply helpful? Yes No