[Gambas-user] Search Between Dates

[Wael M]

Hi all

I have a SQLite database
I need to search between two dates
I'm using this code but doesn't work
it gives no error but returns nothing

 TextBox1.Text = Format(DateBox1.Value, "yyyy/m/d")
  TextBox2.Text = Format(DateBox2.Value, "yyyy/m/d")

  $rs = ModMain.$con.Exec("SELECT * FROM Visits WHERE Vdate BETWEEN '" & TextBox1.Text & "' AND '" & TextBox2.Text & "'")
  
any suggestions?

WaeL