Forum Discussion

Lee_SGilmore's avatar
Lee_SGilmore
Qrew Cadet
7 years ago

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

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 i...
reports and charts
Lee_SGilmore's avatar
Lee_SGilmore
Qrew Cadet
7 years ago
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)