> I don't think the test programme arrived!
>
> Anyway, I have found that using the SQLitte3 DATE function solves the
> problem, so:-
>
> AND DATE(TransDate) >= '2009-07-01' produces the correct result.
>
> Thanks
I'm thinking: contrary to other database systems, sqlite fields are not typed,
t
I don't think the test programme arrived!
Anyway, I have found that using the SQLitte3 DATE function solves the
problem, so:-
AND DATE(TransDate) >= '2009-07-01' produces the correct result.
Thanks
--
View this message in context:
http://old.nabble.com/SQLTE3-%3Edate-function-tp29751718p29776
Dear Benoît,
Please see attached - Ive not done this before, hope it works
Bill Lancaster http://old.nabble.com/file/p29760629/demo demo
http://old.nabble.com/file/p29760629/FMain.class FMain.class
--
View this message in context:
http://old.nabble.com/SQLTE3-%3Edate-function-tp29751718p2976
> 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 recor
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