Dynamic Networkdays expression

[ahmada]

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.

[tresesco · Accepted solution]

Try like:

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

[ahmada]

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