I have two date fields in a table : StartDate and Enddate (the difference between these two represents the delay needed to assemble a machine).
In another table I have a list of days with their date (corresponding to the days the factory is closed).
What I want is, for every day (in the second table) the factory is closed in the gap between StartDate and Enddate, the difference count -1, as the assembling delay should not take care of days of closure.
Example: in format dd/MM/yyyy
Here the assemble delay is 4 days, but should become 3 because 1st of May is a holiday.
I can’t find the right node to compare days of closure with the Start and End dates, as I don’t want to join them because they don’t have the same number of rows.
Note that the holidays table count holidays from different factories and I’m only interested in one of them, I can use factory number as joiner but its not an unique field.
Does someone have a solution for that ? Tell me if my issue isn’t clear.
Thank you for your help.