if ur sql->sp requires a datatime datatype with another param it will works fine in your local dev machine. bt in some cases it doesnt work with the IIS 7.5.

solution1:�either u can change the datetime datatype with varchar(if it is possible). if not then…

here is the solution:

just add this under <system.web>

<globalization culture="en-GB" uiCulture="en-GB" requestEncoding="utf-8" responseEncoding="utf-8" />