Welcome to MyDataOrganizer
Home Products Contact Us Demo Blog

Current Week Tasks - Question from Andrew G.




Andrew G. would like to organize tasks as following:

If the task is completed with PercentComplete = 100 then mark it as completed.
If the incomplete task starts in next 5 days then mark it For Current Week.
If the incomplete task ends in next 5 days then mark it For Current Week.
If the start date of task is in the past and task has not started then mark it as Why task has not started
If the end date of the incomplete task is in the past then mark it as overdue.
If the start date and end date of the incomplete task is beyond next 5 days then mark it as Not Current Week.

Note : Above report in the screenshot was run on Nov 15, 2015(11/15/2015).