lnDaysBack = 5 SELECT *, Month(dob) AS MonthDob, Day(dob) AS DayDob ; FROM mytable ; WHERE dob BETWEEN DATE( YEAR(dob), MONTH(DATE()-lnDaysBack), DAY(DATE()-lnDaysBack)) And ; DATE( YEAR(dob), MONTH(DATE()), DAY(DATE())) ; ORDER BY MonthDob, DayDob ; INTO CURSOR csrReult>i have a date field which stores the birth date of employees.