Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Fix end dates to reflect end of day (for custom quarters and prompts)

Avatar

Level 3

11/27/17

When creating Custom Quarters you enter the start and end date (e.g. Q1 = 2/1 - 4/30). However, the system uses the beginning of each date as in 12:00am or 00:00:00 to run it's calculations (e.g. 2/1 00:00:00 - 4/30 00:00:00). So you will lose any activities that exist between 4/30 00:00:01 - 4/30 23:59:59). They will not count into the next Custom Quarter either as it would not start until 5/1 00:00:00.

This can be worked around (but not resolved) by moving the Custom Quarter end for Q1 out by 1 (e.g. 2/1 00:00:00 - 5/1 00:00:00). Q2 start and end would then be 5/1 00:00:00 - 8/1 00:00:00 HOWEVER this creates an overlap

1) any task/project/hours/etc that occur on 5/1/2017 00:00:00 will be double counted as existing in both quarters

2) similarly, the information will be duplicately visualized when grouping by custom quarter

So back to square one.

The Idea: For Custom Quarter creation, since we cannot control the date/time, please force the end date of the range to always reflect end of day of the end date as in 23:59:59.

The same request goes for prompts on any report.

2 Comments

Avatar

Level 10

2/25/20

The way the end date is implemented right now does not make sense! I've now users more access with report prompts and they will use the custom quarters because it's the easiest. Some entry dates don't look at the time factor but like for hour reports, it looks for the time factor. The reports will now be inconsistent if they use the custom quarters as some will include the another day of the next quarter if I want to ensure the time factor is looked at.


Who actually says that their quarter ends on 12:00am of the last day?!!

Avatar

Level 10

2/26/20

Unfortunately this is just one more reason justifying our use of an external database to reconcile financial matters; our various financial and accounting gurus don't trust WF's reporting and assumptions.


Definitely upvoting in the hopes that WF gets their fiscal house in order some day.