NetworkDays in script

[pipuindia99]

Hi All,

Have an issue with networkdays function when i use it script

There is a holiday on 6/6/2019 for a country. and in the below script there are multiple countries involved and for each country there are common and also different holidays. 

so the question is how to assign the values of dates to a variable so that the variable can be used in networkdays function as a 3rd parameter if we select a country in list box.

example

LOAD * Inline
[Indate, Outdate
6/5/2019, 6/7/2019];

Holiday:
LOAD Slno,
Country,
Num([Holiday_Date]) as Public_Holiday_Date_Num,
date(Holiday_Date) as Public_Holiday_Date,
FROM
[..\..\Holiday list 2019_US_EU.xlsx]
(ooxml, embedded labels, table is Sheet1);

Holiday_List:
load
concat(chr(39) & Public_Holiday_Date_Num & chr(39),',') as ListOfHolidays_Num,
Country
Resident Holiday Group By Country;

DROP Table Holiday;

LET vListOfHolidays = ; ????

EXIT SCRIPT;

[Gysbert_Wassenaar]

Holiday_List:
load
concat( Public_Holiday_Date_Num,',') as ListOfHolidays_Num,
Country
Resident Holiday Group By Country;

DROP Table Holiday;

LET vListOfHolidays = '=Only(ListOfHolidays_Num)'  ;

[pipuindia99 · Accepted solution]

thanks Gysbert, it worked i tried mulitple ways like using peek, fieldvalue and even only function as well, nothing worked. and now i remember to include "=" in front of only 🙂