I am trying to create two different views for work anniversary and birthdays to only show if the current month is the same as hire date and birth date.
I have the following calculated column, which returns a Yes/No value: (the column is called BirthdayThisMonth
)
=IF(MONTH(NOW())=MONTH([Birth Date]),"Yes","No")
It works as intended which is good, the issue is when I go to create a new list view, I set the filter to: BirthdayThisMonth
is equal to Yes, and I load the view but nothing populates?
There are list items that contain Yes values but they are not showing?