>Hi Borislav,
>
>thanks.
>
>>
>>m.startdate = RIGHT(DTOS(UsersStartDate), 4)
>>m.enddate = RIGHT(DTOS(UsersEndDate), 4)
>>
>>WHERE BETWEEN(RIGHT(DTOS(DOB), 4), startdate, enddate)
>>
You are welcome
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.