|
Cookie -> Weird Happenings! (2/7/2002 6:36:43)
|
I am currently usinng a form called edit.asp that I can edit the crrent data, which in turn submits to update.asp to update the data.
My problems seem to lie in the two date fields (Start Date & Finish Date). I have two problems with this:
Problem 1)When I fill the form out, if you leave either of the fields blank it will automatically post the date 01/01/1900.
Problem 2)When you input the date in the format dd/mm/yy and post it to update.asp you get the following message:
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Number: -2147217913 (0x80040E07)
Source: Microsoft OLE DB Provider for ODBC Drivers
One or more form fields were empty. You should provide default values for all form fields that are used in the query.
Yet if you post it in the format mm/dd/yy it will update it. BUT when you review the list , it has inputted it in the format dd/mm/yy!
Any ideas? PLEASE HELP!
Thanks
Dave
|
|
|
|
