On Thu, 8 Oct 2009, Pavel Ivanov wrote: > Your dates are compared as simple strings. Thus with your statement you're > trying to delete all rows where DateIssued is January, 1 of any year > earlier than 2005. Bottom line: change the way you store your dates if you > really want to compare them in sql statements.
Pavel, I changed the data type in the schema to VARCHAR and the format is now YYYY-MM-DD. However, it's still not working. What am I still doing incorrectly now? Thanks, Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users