Answered

Check for holiday ignoring the year

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a holiday in my collection on 2/11/1947. If i check for this holiday on 2020 it wont appear as a holiday.

I set a label with text property

If( Text(DateValue("2020/2/11"), "[$-en-US]mm/dd") in HolidaysCollection.StartDate, "Holiday", "Not Holiday" ) . The result was "Not Holiday"

How can i recognize a holiday regardless the year?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Try this

If(IsBlank(LookUp(HolidaysCollection, Text(DateValue("2020/2/11"), "[$-en-US]mm/dd") = Text(DateValue(StartDate), "[$-en-US]mm/dd") )), "Not Holiday", "Holiday" )

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

I made a collection like this

ClearCollect( HolidaysCollection, {StartDate: Date(2020,02,11)}, {StartDate: Date(2020,01,29)}, {StartDate: Date(2020,02,08)}, {StartDate: Date(2020,03,03)} )

And then I put this code in the text property of a label

If(DateValue("02/11/2020") in HolidaysCollection.StartDate, "Holiday", "Not Holiday" )

It displayed "Holiday"

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Tried this and it doesnt work. For every DateValue it will always display "Holiday". I changed DateValue("2020/2/11) to DateValue("2020/2/13) and appears as a holiday even if its not

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous
I made a small tweak quickly after my initial post. Double check that your formula is the one that is posted above now. It's working on my end.
If(IsBlank(LookUp(HolidaysCollection, Text(DateValue("2020/2/11"), "[$-en-US]mm/dd") = Text(DateValue(StartDate), "[$-en-US]mm/dd") )), "Not Holiday", "Holiday" )

Was this reply helpful? Yes No