>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)