Send Employees Birthday before weekend

[Jassim Rahma]

Hi,

I have employee birthday table and I am sending daily greetings to the employee based on calendar_day and calendar_month fields where I store the day and month of the employee.

Some of the employees birthdays occurs on weekend (here it's Thu & Fri) so I want to make sure I don't miss greeting them too so I want to do the same what I am doing now:

SELECT * FROM employees
WHERE calendar_day = param_day
AND calendar_month = param_month

where param_day passing the current day and param_month is the current month

so for example if today is 22 Oct then it will list all employees whom they have their birthday today

But if I have an employee's birthday tomorrow (Friday 23 Oct) or (Saturday 24 Oct) I also want them to be shown because Friday and Saturday is a weekend and it is unfair not to greet them.

How can I do this please?


Thanks,
Jassim