Hi,
I have a form which is submitting the date in UK format, i.e dd/mm/yyyy. If i submit the form like this it comes up with the error:
"The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value"
And if i change the date on the form to mm/dd/yyyy it goes through and inserts into the db. However it inserts it into the db as dd/mm/yyyy.
Why is this happening and if its converting it why cant i insert it as dd/mm/yyyy in the first place. Its driving me nuts. Any help much appreciated.
Thanks,
Dan
I have a form which is submitting the date in UK format, i.e dd/mm/yyyy. If i submit the form like this it comes up with the error:
"The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value"
And if i change the date on the form to mm/dd/yyyy it goes through and inserts into the db. However it inserts it into the db as dd/mm/yyyy.
Why is this happening and if its converting it why cant i insert it as dd/mm/yyyy in the first place. Its driving me nuts. Any help much appreciated.
Thanks,
Dan
