[Gambas-user] SQLTE3 >date function

[Benoît Minisini]

> I want to extract records between 2 dates from a date type field
> (TransDate) but using:-
> 
> hResult = FMain.$hConn.Find("transactions", "TransDate >= '2009-07-01')
> produces the same result as
> hResult = FMain.$hConn.Find("transactions", "TransDate > '2009-07-01').
> 
> Also sometimes records 1 day older than requested can be returned.
> 
> Using strftime seem very tricky for say dates between 2009-06-30 and
> 2010-07-01.
> 
> Any thoughts?
> 
> Bill Lancaster

Can you make a little sqlite database with a little project that shows the 
problem?

-- 
Benoît Minisini