Discussions

Expand all | Collapse all

Changing the Week Starting on a Summary Report from Sunday to Monday

  • 1.  Changing the Week Starting on a Summary Report from Sunday to Monday

    Posted 08-16-2018 15:17
    Currently I'm building out a payroll application and trying to provide summary level data using the Summary Reports. When summarizing by Date and for a Week, it list "Week Beginning on Sunday". This is confusing my users greatly as we're focused on Monday being the start of the work week. I can't seem to find an override for all of the default report date filters and criterias. It's all based on a Sunday start for the week.

    Construction just doesn't work that way. There has to be a better means to modify the global calendar settings.


  • 2.  RE: Changing the Week Starting on a Summary Report from Sunday to Monday

    Posted 08-16-2018 15:25
    Okay, I figured out a means to trick the system. I had to build a field that returns the Monday based on a Date. I then had to summarize by this field on a Day level, not a week. My frustrations still exist as I have to modify all of my date filters in reports since the QB system still views Sunday to Saturday as a week.

    FirstDayOfWeek([Date])+Days(1)


  • 3.  RE: Changing the Week Starting on a Summary Report from Sunday to Monday

    Posted 08-16-2018 15:37
    Worst yet, there is the simplest setting in the App Properties that I missed. Now all my frustration is focused on my own incompetence.


  • 4.  RE: Changing the Week Starting on a Summary Report from Sunday to Monday

    Posted 08-16-2018 17:23
    Don't get down on yourself... we've all been there :-)


  • 5.  RE: Changing the Week Starting on a Summary Report from Sunday to Monday

    Posted 08-16-2018 17:53
    Yeah the dropdown for that is buried down in the app properties page if it isn't something you are looking for.