Filter on date column with random years on SharePoint
Usecase You have a SharePoint list with birthdays, on a date column, but dont know how to filter on them to show the last few days or upcoming few days if someone has (had) their birthday.
I couldnt figure out how to do this, and then a colleague of mine Remco Bruijstens (thank you!) suggested this method, and after testing it worked. Kudos to him, and I wanted to share with you how to accomplish this.
