Hi Thanks for your reply, I tried various options including changing the server regional settings and locales, it did not work. Finally I changed the date format in sqlsrv.prm file on the web I server to ‘dd/mm/yyyy’ and re booted the server. Now all looks fine.
The link below helped me in sorting out the issue.
[/url]Out-Of-Range Date Time Value:WIS 10901
venkatpuram (BOB member since 2008-07-25)