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 !