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