Thanks once again. I was figuring out that and your post helped me.

I have tweaked it a bit as max is working fine for date's stored in nvarchar column

here is...

Thanks for the quick reply.

That works. but the problem is I am getting the multiple columns. I think I need to figure out a way to merge these multiple...