AnsweredAssumed Answered

Calculate result betwen 2 dates excluding holidays

Question asked by nicolaslens on Sep 6, 2018
Latest reply on Sep 6, 2018 by beverly

Hy guys, i'm having a Problem when trying to calculate a field.

 

I have a field at "table 1" it contains a date, my request is to calculate how much days of work passed from today until the date in this field. To the calculation i also want to exclude the Holidays, they are also listed in another table (Import from Excel). Any idea how could i do this? I tried Scripting with "Perform Find" but did not accomplished, i'm thinking i should use "ExecuteSQL" but have no idea how.

 

 

Thank you all for your answers!

Outcomes