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
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?