Discussions

Expand all | Collapse all

Unique week/month start and end days

  • 1.  Unique week/month start and end days

    Posted 06-14-2018 14:07
    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.

    Also, my month ends on the 21st and begins on the 22nd.

    Any way I can work around this to create an accurate weekly and monthly summary using those parameters?


  • 2.  RE: Unique week/month start and end days

    Posted 07-13-2018 21:20
    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.