Looks like this...<BR><BR>UPDATE PostWire SET EndDate=CAST('15/09/2001 9:05:09 PM' AS DateTime) WHERE PostWireID=1013<BR><BR>I've changed my SQL statement to include the "AS" but now I get a brand new error<BR><BR>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.<BR>Number: -2147217913 (0x80040E07)<BR>Source: Microsoft OLE DB Provider for ODBC Drivers<BR><BR>I'm going NUTS with this **** date!!!
Sigh. You either have the db field set as a datetime and then are trying to evaluate that field to a string (contained in your EndDate variable) OR your db date field is a datatype of char (I really hope this isn't the case) and you are trying to compare that to a datetime value. Either way, you are trying to compare a string to a date and that won't work.<BR>Convert your variable to a date<BR>EndDate = whatever<BR>EndDate = CDate(EndDate)<BR>OR<BR>EndDate = CDate(Request("Field"))