> 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
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
