Group and filter by "customized week"

To add to what my esteemed QSP colleague, Xavier,  posted above, you were looking for a compact field suitable as a Dynamic Filter.

This formula should return the Wednesday of each period in he format YYYYMMDD, which will sort nicely as a Dynamic Filter.

var date D = [Approval Date];

var date Week = FirstDayOfWeek($D- Days(3)) + Days(3);

var Text YYYY = ToText(Year($week));
var text MM = PadLeft(ToText(Month($Week)),2,"0");
var text DD = PadLeft(ToText(Day($Week)),2,"0");

$YYYY & $MM & $DD

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