I'm trying to use Firstworkdate to evaluate the previous working day, using a different set of holidays on a line by line basis depending on country.
My Test case is FR (France) for MAR-2019. For every record I want to take into account holidays in SG and US, hence the two variables, vHoliday_SG and vHoliday_US.
VALUE_DATE_PAYMENT_0 gives a date of 22-Apr which is correct but does not take into account local holidays
VALUE_DATE_PAYMENT_1 gives a date of 18-Apr which is correct and uses 43577 (22-Apr) hardcoded
VALUE_DATE_PAYMENT_2 gives a date of 18-Apr which is correct and used vHolidays_FR
VALUE_DATE_PAYMENT_3 gives a date of 22-Apr which is incorrect because it does not take into account local holidays i.e. FR
VALUE_DATE_PAYMENT_4 gives a date of 22-Apr which is incorrect because it does not take into account local holidays i.e. FR
How can I get Firstworkdate to take into account local holidays on a line by line basis, by either using the LOCAL_HOLIDAYS field or the vHolidays_XX variables where XX is based on COUNTRY field?
Please find attached source data qvd and qvw in zip file for testing.