Filter for next working day (Mon-Fri)

[G_K_P]

Hello Alteryx Community! I am looking for some assistance with a workflow for the below issue.

With reference to the below sample data, i need help with a filter than can detect the next working day from a date input. i.e. recognize that the 'Date' 8th is a Friday so will filter for those with 'ValueDate' that fall on the Monday (11th).

The best i have at the moment is using the basic filter in the tool for live date = 'tomorrow', but this has the obvious limitation of treating Saturday as 'tomorrow' when the workflow is run on a Friday. It also then doesn't work if the workflow has to be run in advance of the current day/date.

Thank you in advance for your help and time.

Date	ValueDate	Amount
08-Oct-21	11-Oct-21	1000
08-Oct-21	11-Oct-21	2000
08-Oct-21	11-Oct-21	-1000
08-Oct-21	12-Oct-21	-5000

[cmcclellan · Accepted solution]

I think this is what you're after, I added some extra dates to check the logic

[atcodedog05]

Hi @G_K_P 

Here is how you can do it.

Workflow:

Hope this helps : )

[G_K_P]

Thank you so much for the help! Worked perfectly