resolved convert error

[holly]

Hi,

I need help on the below 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

 SQL_str = SQL_str & ",'',''"

Thanks