Has anyone been able to figure out the logic for week to date, standing on yesterday's date, and using Monday as day 1?
Thanks.
[Week Start Data Item]
Week Start Date : _add_days (current_date, (_day_of_week (current_date, 1) -1) *-1)
[Week End Data Item]
Week End Date: _add_days (current_date, - 1)
You filter would look like...
[Your Date Column] BETWEEN [Week Start Data Item] AND [Week End Data Item]
hope that helps!