You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Task Manager Template non consolidation reports are showing dates instead of days (e.g Day -25)

Received Response
61
Views
3
Comments
edited Dec 21, 2023 4:55PM in Financial Consolidation and Close 3 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!