Hi,
I need help on the below code
Code:If RSQAB1!Status_Varchar = "Live" Then
SQL_str = SQL_str & ", CONVERT(datetime,'" & Format(RSQAB1!PolicyStartDate_DateTime, "dd/mm/yyyy hh:mm:ss") & "',103)"
SQL_str = SQL_str & ", CONVERT(datetime,'" & Format(RSQAB1!PolicyEndDate_DateTime, "dd/mm/yyyy hh:mm:ss") & "', 103)"
Else
' SQL_str = SQL_str & ", '" & "" & "'"
' SQL_str = SQL_str & ", '" & "" & "'"
SQL_str = SQL_str & ",'',''"
'SQL_str = SQL_str & "''"
End If
I keep getting a convert error on the below code
ThanksCode:SQL_str = SQL_str & ",'',''"
