Filter data based on current week (weekdays)

I would like to filter out outside of the current week (weekdays).

Example, if i run the flow on the Thursday of this week, i would like to only keep results from Monday to Thursday. If Friday, then Monday to Friday. If Wednesday, then Monday to Wednesday. Exclude any Saturdays and Sundays, and prior weeks.

Tips and Tricks

Date Time

Accepted answers

atcodedog05

Hi @pateldev22

Here is how you can do it.

Workflow:

Hope this helps : )

weekdays filter.yxmd

All comments

atcodedog05

Hi @pateldev22

Here is how you can do it.

Workflow:

Hope this helps : )

weekdays filter.yxmd

jrsheppard

@atcodedog05 This certainly works, however, for review purposes I tend to prefer a more documented approach.

I separate the formulas from the conditions being filtered using a formula tool to create weekdays / week no and a filter tool to filter on the conditions that should be met. See the attached workflow.

WeekdayFilter.yxmd

pateldev22

thank you for the rec! wondering why 02/28 was excluded

pateldev22

also i need the original list of dates to be dynamic based on current week, not as a input data tool

Luke_C

Hi @pateldev22

@atcodedog05's solution is dynamic. The datetimetoday function returns the current date. The %u returns a numeric day of week (Monday is 1, Sunday is 7).

pateldev22

have not had my morning coffee yet. clearly we need the input data tool as a population data set. LOL

atcodedog05

Happy to help : ) @pateldev22

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703