Hi, thx for your reply.

It seem's doest work for me.

i've do as you suggest to me, and produce a query like below :

select PerBirthDate from UDPersonnel where Convert(varchar(5),PerBirthDate,101) <= Convert(varchar(5),'12/05/2010',101)

and...

Thank you for helping, it's work for me.

once again thank alot.

i'm sorry for disturbing again,

i've tried the Last modified query as you write on.

it works, but there some little question for me,

you put a 'd' word in the end of...

Thanks a lot.

🙂

i've read your link chris, but don't get the point.

your modification on the query helped me. thank's alot.

i'll as you later if there another unclear about this age.

thx all.

thank you,,

i've tried it, and write some query like this

select PerName, PerBirthDate, CASE DateDiff(yy,PerBirthDate,GETDATE())

WHEN DateDiff(yy,PerBirthDate,GETDATE()) > 60 THEN 60

WHEN DateDiff(yy,PerBirthDate,GETDATE()) > 55...

thx for the respon, i'll try it.

would you mind if i ask more if there is unclear about this ?