Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks for your assistance.
Hello, could this work?
{<Date={">=$(=Date(WeekStart(today())-7)) <=$(=Date(Weekend(today())-7))"}>}
Thanks for your assistance.