Firstworkdate with holiday

[phongnnguyen]

Dear guys,

I have a problem when use firstworkdate function with holiday list

My field Checkwd: is holiday determine, if Holiday or weekend 1 other is 0

this is my expression. I want find 5 day past without holiday and weekend.

firstworkdate(max(Tradedate),5,concat({<checkwd={'1'}>}Tradedate,','))

for example: they are holiday in my Tradedate

13 Jul 2018

15 Jul 2018

17 Jul 2018

max(tradedate)=17 Jul 2018 - >and my expected result when apply expression is 9 Jul 2018

Many thanks for your help !