View Single Post
To many of mine are showing as imminently overdue so I'll have to leave that as an exercise for the reader, for the moment :-)

For the display of years with strftime:
http://www.sqlite.org/lang_datefunc.html

To eliminate uncompleted tasks of completed projects, I think you could begin by trying to expand t.dateCompleted is null in MATCHES to something like p.status = 'active' and t.dateCompleted is null