Johnny23
Mar 21st, 2001, 08:47 PM
date formatting ..
my country requires dd/mm/yy
and im using dreamweaver ultradev designing a form with an sql7 backend database for some reason if i submit a date in the required format i get this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[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.
/THEREALSITE/admin/TMPc1engakw11.asp, line 90
but when i input my date on my form as mm/dd/yy then it accepts it yet saves it to my database as dd/mm/yy ??
i dont understand please help me out ??
is there some setting that im unaware of ??/?
my country requires dd/mm/yy
and im using dreamweaver ultradev designing a form with an sql7 backend database for some reason if i submit a date in the required format i get this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[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.
/THEREALSITE/admin/TMPc1engakw11.asp, line 90
but when i input my date on my form as mm/dd/yy then it accepts it yet saves it to my database as dd/mm/yy ??
i dont understand please help me out ??
is there some setting that im unaware of ??/?