Unique week/month start and end days
I have a Daily Date column as well as at Mileage Qty column. I want to create a summary report that shows total Mileage Qty per week and per month. However, my week is Thursday-Wednesday. Als...
Forum Discussion
Most likely, you'll need to create a Weeks and a Months table and have either the Week Beginning or Week Ending date as your key field for the Weeks table. You would then have a formula on each record that could identify which week it belonged to based on the date.