Highlighting a date

(0) Share

Report

Posted on by peter5164

I am having a problem with highlighting the birthday months in a list of people. If their birthday is today it is highlighted as yellow, if (this month)Orange and people whose birthday is next month (OrangeRed). I am using the 'TemplateFill' section to this with the following code

If(Day(ThisItem.DOB) = Day(Today()) And Month(ThisItem.DOB) = Month(Today()),Yellow,Month(ThisItem.DOB) = Month(Today()),Orange ,Month(ThisItem.DOB) = Month(Today())+1,OrangeRed,White)

This works EXCEPT during December where of course the next month should be 1 but calculates to 13.

Any ideas on how to fix it?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@peter5164

Change … +1 … to

… + If(Month(Today())=12, -11, 1) …

Was this reply helpful? Yes No
peter5164 on at

Like
a
(0)

Report
Copy link

Link copied!

Simple when you know how!
Thank you!

Was this reply helpful? Yes No