[Kazza]

Hi
Thanks for the script Rob. I've managed to make a few tweaks to suit my needs but now I'm stuck. I want get some numbers on how old some incomplete tasks are.

e.g. something like this:

Modified
<= 1 Month 130
> 1 Month and <= 2 Months 12
> 2 Months and <= 3 Months 50
> 3 Months and <= 6 months 16
> 6 Months and <= 12 months 12
>12 Months 8

I tried to understand how SQLite does its dates but I can't. I got into sqlite3 and attached to the db OK. I then ran this to look at a few tasks:

select dateModified, date(dateModified), name from task where inInbox = 1 and (dateCompleted is null);

371086241.164303|1011287-12632210-20|empty tank
371086282.211984|1011287-12632211-31|find xxx
371086440.284924|1011287-12632217-05|reply yyy on FB
371086613.883444|1011288-12632210-28|blah blah
371089001.703324|1011294-12632217-11|ring ZZ

All these task were entered today, 2012-10-05.....so I don't understand this date system.

I'm also stumped on how to do the date manipulation I need in SQL.

And finally: If possible I'd also like to exclude the tasks from projects in my templates folder as these aren't tasks to work on.

Any clues anyone ?

thanks
Kazza