Hi Nick,

>>This works too, I just didn't give the my original too much thought

>>lnyear = YEAR(DATE())
>>SELECT *;
>>  FROM CLIENTS;
>>  WHERE BETWEEN(DATE(lnyear, MONTH(clients.dob), DAY(clients.dob)), dstart, dend)

Empty birthdates shouldn't be allowed.< g >
>
>This will not work properly if dstart and dend belong to different years, i.e for the period starting say, in November and ending in February.
>
>This one-liner will work in VFP 3, 5, 6 and 7 :) and it is not using any kind of date parsing, concatenation and CTOD() stuff.
>
>SELECT * FROM CLIENTS ;
>WHERE BETWEEN(GOMONTH(birth_date,(YEAR(start_date)- YEAR(birth_date))*12), start_date, end_date ) ;
>OR BETWEEN(GOMONTH(birth_date,(YEAR(end_date)- YEAR(birth_date))*12), start_date, end_date)

As always, this simple task could be done in at least three ways, but your solution seems to be more efficient and elegant. :)