I am trying to get date testing and manipulation to work. Should this work:
select julianday('now') - julianday(startmonday) from wb startmonday is a text field that contains 2009-03-30. Also the following returns 'none' select julianday(startmonday) from wb Any help would be much appreciated Kind Regards Garry (Sqlite newbie) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users