2018-04-12 17:08 GMT+02:00 Keith Medcalf <kmedc...@dessus.com>: > > select TheDate from Dates where TheDate == date('now');
Yes, but I want the CASE because if there is no such date in the Dates table which is equal to the date('now') then it should return the date('now','+1 day'). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users