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?