resolved convert error

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

Code:

---

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

---

Thanks

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:

Code:

---

SQL_str = SQL_str & ", Null, Null"

---

Quote:

---

Originally Posted by 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:

Code:

---

SQL_str = SQL_str & ", Null, Null"

---

---

Thanks Si for all you help!!!

:wave: