Hi again Gail,

Sorry, I didn't notice that you edited your previous post.

I tried what you suggested in your edited post with a little change to the syntax and it's...

Hi Gail,

thanks for the reply.

i tried the date format that you suggsted but it still producing the same error.

i have already mentioned that i tried all the possible formats...