Skip to Content
0
Jun 07, 2022 at 03:23 PM

Group report by specific date & time range w/o parameters

63 Views

I am trying to create a report to show the total product weight that our company brings in per fiscal week, but our week days & hours are set differently due to inventory than a regular calendar. I am trying to group the weight per week, but I am having a hard time coming up with a formula to do this for me rather than a parameter for each day. Our weeks are Monday 6:00:00am to the following Monday 5:59:59am.