Filter date including Weekend

[Vincent_Nuestro]

Hi, this is also related to my previous topic.

But now, I would like to filter it including Saturday and Sunday.

SAME SCENARIO.

Filter date but not include Weekend

Hi In my condition here is I need to filter out the Date less than 14Days of Effectivity date (Not included the weekends) Condition: Days Before Effectivity date >=14Days if Current Date >= 14 days of Effectivity Date ~WriteLine~ Success Else Current date < 14days of Effectivity Date ~WriteLine~ Failed Please see sample below for reference [image] Thank you in advance. -Vincent

I tried already to revised the workflow solution but im still not getting the right output.

can somebody help me pls.

Thank you in advance
-Vincent

[ppr (Peter Preuss)]

Parsing the effective date column should be the same (prototyped with the new DateTime)
Then the simple substraction with - will return a Timespan from which we get back the number of days with .Days

[Vincent_Nuestro]

hi @ppr can you share me you Workflow pls?

[ppr (Peter Preuss)]

as you can see it was quick done during a debug runf within the immdeiate panel. You can do the same directly also on your end