Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to show how many days left in the quarter and year using NetWorkDays. Its not recognizing the holidays I'm entering. I should show 43 days left in the quarter and its showing 44.
This is my expression for the quarter:
NetWorkDays(Date(today(),'5/27/2024'),QuarterEnd(Date(today(),'5/27/2024')))
And the year:
NetWorkDays(Date(today(),'1/01/2024''5/27/2024''7/04/2024''9/02/2024''11/21/2024''11/22/2024''12/25/2024'),YearEnd(Date(today(),'1/01/2024''5/27/2024''7/04/2024''9/02/2024''11/21/2024''11/22/2024''12/25/2024')))
Hi, @lneff
I would work this into the script by bringing in these holidays with a mapping, using either an inline or a table for holidays.
Then you could create a flag and later use it in your application.
See the example below; this is just an example and you can adapt it to your data if you find it useful.
Regarts, Matheus