Filter Previous Week Per Day Any Day This Week

Question

Hello!

I ran my build last Monday and it worked, all of the data from the previous week was filtered correctly.

However, today (Wednesday) when I ran the build it included Monday, Tuesday and Wednesday of this week. Have attached the 2 workflows here.

I would like my build to be able to filter previous week's daily data regardless of the day I ran the build in the current week.

I tried and I just can't make it work.

Appreciate the help please.

Date Formatting Previous Week Per Day.yxmd

atcodedog05 · Accepted Answer

Hi @Steph

Your ranges didnt seem right can you try this workflow. I am treating Monday as first day of the week.

Hope this helps : )

SPetrie · Accepted Answer

Just to toss this out as an alternative answer if you dont want to use a switch statement. I have the Sunday and Monday versions in the workflow.