Comparing dates with the time and without a delegation warning

(1) Share

Report

Posted on by Rieus

143

Hello,

Is there a better way to do this without getting a delegation warning?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @Rieus ,

can you update your formula like this:
Year(Datum) = Year(dtpStartDate.SelectedDate) && Month(Datum) = Month(dtpStartDate.SelectedDate) && Day(Datum) = Day(dtpStartDate.SelectedDate)

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
Rieus 143 on at

Like
a
(0)

Report
Copy link

Link copied!

It still gives a delegation warning 😕

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Rieus ,

I may be missing something obvious here but assuming Datum is a Date field (and you are using SharePoint)

Filter( Tijdsloten, 'Team nummer' = TeamNr.Value && Datum = dtpStartDate.SelectedDate )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Rieus 143 on at

Like
a
(0)

Report
Copy link

Link copied!

That's what I did at first but it doesn't work at all that way. I assumed it was because of the hours and the minutes. If I could only strip both dates of hours, minutes and seconds perhaps then the comparison would work.

Was this reply helpful? Yes No
Verified answer

Rieus 143 on at

Like
a
(0)

Report
Copy link

Link copied!

EDIT: I overlooked that I still had a delegation warning. This is the actual solution
2ND EDIT: There was still an error hidden by a preview feature, your date property should be on the left side and that which it is compared to on the right. See:
https://powerusers.microsoft.com/t5/Building-Power-Apps/I-changed-the-Display-name-of-table-column-and-now-I-seem-to-get/m-p/2319206/emcs_t/S2h8ZW1haWx8dG9waWNfc3Vic2NyaXB0aW9ufExMVVRBSE9CSU9NSjJXfDIzMTkyMDZ8U1VCU0NSSVBUSU9OU3xoSw#M579470

Someone on Discord found this solution.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Delegation-warning-using-Month-and-Year-function/m-p/1698902#M432466

Was this reply helpful? Yes No