Happy Birthday In Program

User_VIYD9

Hello All,

I have created some SQL views for each month (1-12) to pull people from each month respectively. My original plan was to use them as a refresh view in program, but I am having trouble figuring out how to have them enter once a year - starting on a certain date.

Any ideas?

Phil Allen

Is there a reason for not making the view query where BIRTH_DATE = today() ?

This would mean it would only return the users who have their birthday today.