Task Manager Template non consolidation reports are showing dates instead of days (e.g Day -25)
Hello Everyone,
I have an issue with Task Manager reports and need your help.
The Task Manager Template non consolidation reports are showing dates (2009-06-20T13:00:00, 2009-06-26T01:00:00) instead of days (e.g Day -25, Day 20). The report is not helping as it has dates instead of days.
When creating a task, I have just mentioned the day and not the date and not sure why the report is pulling it as date. I tried to customize the query by taking just the day number from the from the start date and then subracting 15 and for end date subracting 16 to get correct days which is working for most of the days but it is not helping if the start date goes into prior month or the end date goes in next month.