Show last week's data

[MikeJones]

Hi all, I wish a table to show Monday to Friday data for the previous week.

For example should I look at the table on 19th March, the dates showing will be cover Monday 11th March through to Friday 15th March.

When I look at this table say on Wednesday 27th March, the dates showing in the table will run from Monday 18th March to Friday 22nd March.

I have been around in many circles trying to use WeekStart, but alas I get nowhere.

I don't have the ability up load a qvf file.

[Clement15]

Hello, could this work?

{<Date={">=$(=Date(WeekStart(today())-7)) <=$(=Date(Weekend(today())-7))"}>}

[MikeJones · Accepted solution]

Thanks for your assistance.