I have a query not working correctly with the dates
field DateProv = DateTime ie '15/07/2017 10:12:10'
string FromDate = ShortDate ie '15/07/2017'
SQLstr = "SELECT * FROM Phones WHERE Status = 'OK' AND Format(DateProv, 'dd/mm/yyyy') >= #" & FromDate & "#"
Sometimes it will select DateProv before FromDate, Im using the Format() function to convert DateProv from DateTime to ShortDate
field DateProv = DateTime ie '15/07/2017 10:12:10'
string FromDate = ShortDate ie '15/07/2017'
SQLstr = "SELECT * FROM Phones WHERE Status = 'OK' AND Format(DateProv, 'dd/mm/yyyy') >= #" & FromDate & "#"
Sometimes it will select DateProv before FromDate, Im using the Format() function to convert DateProv from DateTime to ShortDate