Quoting [email protected]: > 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) Sorted it, I had the wrong date format in the field!! Thanks anyway Garry
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
