Week to date logic

[pammassey]

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.

[Ravisha]

[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!