Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to calculate the amount of work days in the current month.
I need to account for the weekends and holidays. I currently have a string variable with all of my selected holidays defined as 'vHolidays'.
Here is the expression I am trying to use to achieve said count. The current amount of days for this month would be 20, 4th of july.
=networkdays({$<Date={"$(=FirstWorkDate(Today()-1,1,$(vHolidays)))"}, Month = {"$(=Month(Today()))"}>} min(Date), max(Date))
I would not know anything about this because I don't have any knowledge about your data. If Max(Date) = 08/01/2017, you will have to check in the database as to why you are getting this value....