[Gambas-user] Search Between Dates

Wael M wael79xy at yahoo.com
Sun Oct 7 01:19:03 CEST 2018

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?


More information about the User mailing list