dbQuery = "SELECT * FROM table WHERE date BETWEEN " & startDate & " AND " & endDate & ""
When i execute this statement in NaviCat it does not return any values either. Tho the values do exist on the 19th and 22nd of June in 2015. am i sending the query wrong???
Upon debugging the query is sent as follows.
select * from table where date between 6/1/2015 and 6/31/2015
Aucun commentaire :
Enregistrer un commentaire