Group and filter by "customized week"

Ou will need to create a text field which calculates to the choices that you want.  Then use that text field as a Dynamic Filter.

Post back if you ned help on how to write the formula being very clear how you want the text to read (or maybe you want it similar to the screen shot and if so, at what point if any, do the dates get grouped in "really old" or "really far ahead".

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

A couple different options here:

1)  Change the global "start of week" for the entire app
- in App Properties > App date and time > Date options
- you can set First day of week to "Wed"
- then your normal grouping in table and summary reports will use the new setting with Wednesday as first day of the week
- this only works if this Wednesday week setting will work for all the dates in your entire app

2)  Create a custom formula to display the custom week

- create a Formula Text field - let's say you call it something like Custom Week Starting Wednesday
- use this formula (this is assuming that your current First day of week is set to Sunday)
- use this formula:

var Date CurrentWednesday = FirstDayOfWeek([Sent to 1st Level Review]) + Days(3);

var Date PreviousWednesday = $CurrentWednesday - Days(7);

If ([Sent to 1st Level Review] < $CurrentWednesday,
"Week of Wednesday - " & ToText($PreviousWednesday),
"Week of Wednesday - " & ToText($CurrentWednesday)
)

Now this text column will display something like:
- Week of Wednesday - 07-31-2019
- Week of Wednesday - 08-07-2019
etc.

If you group using this Formula Text column in your table or summary reports - then the grouping will be by week, starting on Wednesdays.

If you have multiple different custom weeks, then your formula will need to account for them, or you can create separate Formula Text fields for the different weeks.

------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/
------------------------------