Dynamic Networkdays expression

ahmada — Thu, 28 Nov 2019 13:37:39 GMT

Hello,
I have a question about the formula "networkdays()".
I have a calendar with %Date and Year and in the script the holidays defined as variable.

I would like to select a year and have the days calculated from the beginning of the selected year.

I tried this formula: networkdays(YearStart(%Datum), today() ,vHolidays). Unfortunately the (YearStart(%Datum) does not work in the function.

But the formula = networkdays(YearStart(today()), today() ,vHolidays) works. But I want to filter with the year.

I hope you can help me. Kind regards Ahmad.

Re: Dynamic Networkdays expression

tresB — Thu, 28 Nov 2019 13:44:37 GMT

Try like:

networkdays(YearStart(Max(%Datum)), today() ,vHolidays)

ahmada — Thu, 28 Nov 2019 13:49:07 GMT

Thank you so much for your help. It worked directly. 😀