calculate difer date and time

(0) Share

Report

Posted on by Setayesh2

105

Hi,

would you advise how to calculate different dates and times in the power app?

TotalTime is a text column in SharePoint

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Setayesh2 105 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried this function but it works for saved data. I need to calculate them at the time of change.

With(
{
days: RoundDown(DateDiff(ThisItem.Start, ThisItem.End, Hours) / 24, 0),
hours: Mod(RoundDown(DateDiff(ThisItem.Start, ThisItem.End, Minutes) / 60, 0), 24),
minutes: Mod(DateDiff(ThisItem.Start, ThisItem.End, Minutes), 60)
},
days & " day(s), " & hours & " hour(s) and " & minutes & " minute(s)"
)

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Setayesh2

The data in your formula is the value obtained from the data source. If you want to obtain the value from the control, should refer to the value of the control.

Please try following formula:

With( { days: RoundDown(DateDiff(DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 ), DateValue2.SelectedDate + Time( Value(HourValue2.Selected.Value), Value(HourValue2.Selected.Value), 0 ), Hours) / 24, 0), hours: Mod(RoundDown(DateDiff(DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 ), DateValue2.SelectedDate + Time( Value(HourValue2.Selected.Value), Value(HourValue2.Selected.Value), 0 ), Minutes) / 60, 0), 24), minutes: Mod(DateDiff(DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 ), DateValue2.SelectedDate + Time( Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0 ), Minutes), 60) }, days & " day(s), " & hours & " hour(s) and " & minutes & " minute(s)" )

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Setayesh2 105 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-LilyW-msft thanks a lot. Would you also advise how I can control End date, to not set less than start date?

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Setayesh2

If you want to set End Date should be greater than Start Date you can refer to below link to see if it helps.

https://www.c-sharpcorner.com/article/power-apps-validation-end-date-and-time-should-be-greater-than-start-date-and/

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No