Would something like this be the best way, or is there another better way?
WHERE BETWEEN(RIGHT(DTOS(dob),4), RIGHT(DTOS(DATE() - 1),4), RIGHT(DTOS(DATE() + 1),4))
>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?