I have not used the date function in select statements before.
I have valid entries for the current month, what am I doing wrong?
SELECT * FROM "entry" WHERE
bankdate > date('now','end of month','-1 month')
AND bankdate < date('now','start of month','+1 month')
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/select-with-date-tp71216.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
