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

[si_the_geek]

It would be useful to know what the error message is, and what you are trying to achieve with that code.

In this case I suspect what you are trying to do is leave that column blank, is that correct?

If so, and assuming that the lines with Convert in them work, you should be able to use this:

 SQL_str = SQL_str & ", Null, Null"

[holly]

It would be useful to know what the error message is, and what you are trying to achieve with that code.

In this case I suspect what you are trying to do is leave that column blank, is that correct?

If so, and assuming that the lines with Convert in them work, you should be able to use this:

 SQL_str = SQL_str & ", Null, Null"

Thanks Si for all you help!!!