Holiday Date Filter

[AshishAgarwal]

Please help to figure out below.

I have list of input data file for many days of 2021.

I need to pick up data of Holiday date till last working day.

For ex:

Date	Topic
17-Sep	Working Date
20-Sep	Holiday
21-Sep	Working Date
22-Sep	Working Date
23-Sep	Holiday
24-Sep	Working Date

I need to pick up only 23rd Sept date file when I am running workflow for 24th Sept.

I tried working out some workflow but I am getting 2 date file of 20th Sept & 23rd Sept.

Please let me know which step i should modify or add to make workflow simple.

Thank you so much

[atcodedog05 · Accepted solution]

Hi @AshishAgarwal 

Does this work for you.

Workflow:

Hope this helps : )

[AngelosPachis]

Hi @AshishAgarwal ,

Here's another way without a sample tool, flagging if consecutive holidays occur

Hope that does it

[AshishAgarwal]

@atcodedog05 

Thank you so much.

Its working as per expectation.

Will initiate this chat again if I face any issue in that.

Thank you so much once again.

[atcodedog05]

Happy to help : ) @AshishAgarwal 

Cheers and have a nice day!

[AshishAgarwal]

Hi @AngelosPachis 

Thank you so much for helping.

Haven't checked workflow yet however will check and acknowledge this guidance for future reference.

Regards,

Ashish