Hi I need help with the below code as no matter wot I try it keeps inserting
the default #01/01/1900#
thanksCode:If Len(QuoteReq_char) = 0 Then SQL = SQL & ", '" & Null & "'" Else SQL = SQL & ", CONVERT(datetime,'" & Format(QuoteReq_char, "dd mmmm yyyy") & "', 103)" End If SQL = SQL & "," & TargetPrem_money SQL = SQL & ",'" & MakeStrSQLAcceptable(TargetInsurer_char) & "'" If Len(ToCarrier_char) = 0 Then SQL = SQL & ", '" & Null & "'" Else SQL = SQL & ", CONVERT(datetime,'" & Format(ToCarrier_char, "dd mmmm yyyy") & "', 103)" End If
the code is set in an insert stmt to sql server 2000...I have not posted the
whol routine as its big but if need to I will




Reply With Quote