Forums / Tips & Tricks

rajjan

Wow, using the search box, really good work!

An old problem you probably can solve in a few minutes:
Creating a weekend smartlist, with task due this upcoming weekend (when asking mon-fri), today+tomorrow (when asking sat) or today+yesterday (when asking sun)

Posted 7 months ago

rajjan

And of course well worth a Tip of the Week mention - really clever!

Posted 7 months ago

zkestenbaum

Thanks rajjan! I did the weekend one below. The only downside to the search box approach is that it only works in the browser, not in the apps. But hey, better than nothing.

"This weekend"
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setDate(startDateRange.getDate() + (4 - ((startDateRange.getDay() + 6) % 7))); endDateRange = new Date(); endDateRange.setDate(startDateRange.getDate() + 3); searchStr = 'dueAfter:' + dateToString(startDateRange) + ' and dueBefore:' + dateToString(endDateRange); document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null; endDateRange = null;

Posted 7 months ago

rajjan

Thanks a lot, I've spent too many hours trying to fix this using the normal search operators and now it's done!

Posted 7 months ago

rajjan

Found a minor error above, the Last month script is the same as the Last week script, both return Last week tasks.
Had a try at javascript, think this works:

"Last month"
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setDate(0); startDateRange.setDate(0); endDateRange = new Date(); endDateRange.setDate(0); endDateRange.setDate(endDateRange.getDate() + 1); searchStr = 'dueAfter:' + dateToString(startDateRange) + ' and dueBefore:' + dateToString(endDateRange); document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null; endDateRange = null;

Posted 7 months ago

rajjan

Another idea: In order to immediately get a list of what you did last week/month, you could add a and status:completed to these javascripts:

"Last week I did this"
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setDate(startDateRange.getDate() - startDateRange.getDay() - 7); endDateRange = new Date(); endDateRange.setDate(endDateRange.getDate() - endDateRange.getDay() + 1); searchStr = 'dueAfter:' + dateToString(startDateRange) + ' and dueBefore:' + dateToString(endDateRange) + ' and status:completed'; document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null; endDateRange = null;

Otherwise, you could just press the Nnn completed link in the details box to get the same result.

Posted 7 months ago

ranbarton

Whoa - coolest tip on these boards in a long while. Very, very clever.

Posted 7 months ago

rajjan

I totally agree (which you probably could guess from the posts above ;-)!

zkestenbaum: I found some minor errors, I hope you don't mind the corrections.

Slight improvments to the scripts above, using completedAfter/Before in order to see what you really did, not only what was due. No need to include the "and status:completed" mentioned above I noticed. I also made a slight modification to the start date, making it the first of the month not the last of the month before. Also, the getDate offsets doesn't work around the end of the month in the original postings , getTime is used here instead.

"Last week I did this" ver 2:
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setDate(startDateRange.getDate() - startDateRange.getDay() - 7); endDateRange = new Date(); endDateRange.setDate(endDateRange.getDate() - endDateRange.getDay() + 1); searchStr = 'completedAfter:' + dateToString(startDateRange) + ' and completedBefore:' + dateToString(endDateRange); document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null; endDateRange = null;

"Last month I did this" ver 2
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setDate(0); startDateRange.setDate(1); endDateRange = new Date(); endDateRange.setDate(1); searchStr = 'completedAfter:' + dateToString(startDateRange) + ' and completedBefore:' + dateToString(endDateRange); document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null; endDateRange = null;

"Last 7 days I did this"
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setTime(startDateRange.getTime() - 7*24*60*60*1000); searchStr = 'completedAfter:' + dateToString(startDateRange) + ' and completedBefore:tomorrow'; document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null;

"Month to date I did this":
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setDate(1); searchStr = 'completedAfter:' + dateToString(startDateRange) + ' and completedBefore:tomorrow'; document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null;

"Week to date I did this"
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setDate(startDateRange.getDate() - startDateRange.getDay()); searchStr = 'completedAfter:' + dateToString(startDateRange) + ' and completedBefore:tomorrow'; document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null;

"This weekend"
javascript:function dateToString(date){ return (date.getMonth() + 1) + '/' + date.getDate() + '/' + date.getFullYear();}; startDateRange = new Date(); startDateRange.setDate(startDateRange.getDate() + (4 - ((startDateRange.getDay() + 6) % 7))); endDateRange = new Date(); endDateRange.setTime(startDateRange.getTime() + 3*24*60*60*1000); searchStr = 'dueAfter:"' + dateToString(startDateRange) + ' 23:59" and dueBefore:' + dateToString(endDateRange) + ' and not list:¤Z'; document.getElementById("listFilter").value = searchStr; control.updateListFilter(); startDateRange = null; endDateRange = null;

In order to get dates in the 2012-10-29 format instead of 10/29/2012, modify the dateToString like this:
dateToString(date){ return date.getFullYear() + '-' + (date.getMonth() + 1) + '-' + date.getDate();};

Posted 6 months ago

rajjan

Another idea for those who prefer not to create too many smart lists as they can clutter up the desktop (code borrowed from zkestenbaum, thanks again):

Modify the script below using the normal search operators and save it as a bookmarklet:
javascript:searchStr = 'Modify this part '; document.getElementById("listFilter").value = searchStr; control.updateListFilter();
In this case, the search text will be static, but allows for loads of different saved searches.

If you tend to forget what you've searched for, you could add a dummy NOT-search at the beginning as in:
javascript:searchStr = 'not "Minor tasks" timeEstimate:"<16 min"'; document.getElementById("listFilter").value = searchStr; control.updateListFilter();
Please observe that you have to mix ' and " in javascript in this case.

Tomorrow is Tuesday, I'm curious to find out if this gets the Tip of the Week mention it rightly deserves!

Posted 6 months ago