Hi Cetin
>>btw, i've tried the brackets and it still wont work..but it i use tdate its ok.
>
>Brackets are valid for SQL server.
How about suggesting him to do this in a very tiny prg doing simple date stuff, then he can add things later or copy-paste code into the original. Just my 2 cents.