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:

General Questions

All responses (2)

Answers (1)

peter5164 on at

Like (0)

Report

Re: Highlighting a date

Simple when you know how!
Thank you!
Verified answer

Community Power Pla... on at

Like (1)

Report

Re: Highlighting a date

@peter5164

Change … +1 … to

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