Hi,
I've gone brain dead :(
I have some SQL code:
SELECT dob as dactivity, client_no, PADR("Birthday", 20) as cType;
FROM c_clientlist;
WHERE DAY(dob) = DAY(DATE()) AND MONTH(dob) = MONTH(DATE())
which will give me anybody who was born on the current day.
Say I wanted to allow the user to enter a starting date and an ending date and then I will pull out all people who have birthdays falling within that range.
How do I convert this to work on a range of dates?