In my code i am getting the following error on insert ststement-
---> Conversion of varchar to datetime resulted in out of range value.
I have checked the datatype and the order of the fields in insert query and database as well the daterange.
I have also checked the date format in insertion.Please suggest what could be the error.It is really urgent please reply ASAP.
I think you are in the wrong forum.
Other then that, what is the actual value of the string you are trying to convert to datetime?