VBA sql conversion failed when converting the varchar value to data type int in FILTER BETWEEN dates

[geloader0]

Hi Good day, I have a form with data and search box. I want to filter dates between 2 fields/textbox From and To. But this error appear as shown in the image below.
This is my SQL query . Thank you for the help.

sql = "select [Row Number],[ITEM],[NAME],[SO #],[DATE BILLED] from tblData  " & _
  " where [DATE BILLED] BETWEEN " & dtpFrom.Text & " AND " & dtpTo.Text & "  " & _
  " AND [SYS Payment Rcvd]='' order by [Row Number] DESC "

 

[geloader0]

Anyway, thank you so much for your help. Much appreciated of your time. I will mark this thread as SOLVED. Thanks again.

 

[FormR]

I will mark this thread as SOLVED

Is it solved then?

Did you try the code from post# 28?

 

[geloader0]

Is it solved then?

Did you try the code from post# 28?

Ohh about that code from #28 it gives me this error
I think the problem is this line

str_to_date([DATE BILLED], '%m/%d/%y')

 

[FormR]

Ohh about that code from #28 it gives me this error

You said that about the code in post#24 - do you still get the same error message with the code in post#28?

 

[geloader0]

You said that about the code in post#24 - do you still get the same error message with the code in post#28?

I already find the solution now. TRY_CONVERT statement works. Thank you so much again.

TRY_CONVERT(datetime, [DATE BILLED], 101)

 

[FormR]

TRY_CONVERT statement works

Great, thanks for letting us know

 

[geloader0]

Great, thanks for letting us know

Thank you so much too for your time and effort :D