Filter by less than or equal first business day of the following month

Hi @ipazin,

I was just curious if it is possible to create a dynamic approach to get the desired date. However in course of the analysis and this discussion it turned out, that it will not work without some external source in order to consider not only weekend but also public holidays :smile:. Hence of course your approach is much easier and helps to save time.

Furthermore it helped me to solve the issues with the formats of the dates I had before. I just had to add a modify time node after every table that include dates. So the “complicated” workflow version does now also deliver the correct outcome :wink:. So thanks a lot for that in every respect :+1: . This is how it looks like:


I wanted to upload also the workflow, but unfortunately I get an error message when trying to export it.

Then I tried to adopt your approach to my workflow. However I cannot configure your flow variable and if I copy the nodes, the flow variable is not there anymore… Can you please tell me how you set up this one? Did you do this with a quickform inside the workflow and if yes which one did you select?

1 Like