Hi,
I have a requirement where i have to calculate the Business Day of a particular Date in a Month. The calculation happens from 1st of every month.
Basically my requirement is opposite of workday(), in workday() business day is passed and it provides the date. Here i have the Date and the Business day has to be calculated.
Thanks in advance
Discussion posts and replies are publicly visible
try this function networkdays()
Also can you give some sample input and output?
Networkdays() gives the no of working days between 2 given dates.
My requirement is to get the business day for a given date.
ex - if Todays date is 1st Sept 2021 , then 10th September (10/09/2020) its the 7th business day for the September month.
Hi Preetis,
Pls pass the holiday date also. Also create constant for list of holidays or query from table and pass the holiday dates if your app is having holiday dates information in Database
networkdays( starting_date, ending_date, holidays )
ex:networkdays("09/01/2021","09/10/2021","09/06/2021") -> output is 7
networkdays("12/20/2021","12/24/2021",{"12/22/2021","12/23/2021"})->output is 3
Pls refer the link for documentation
https://docs.appian.com/suite/help/21.3/fnc_date_and_time_networkdays.html
Hope this helps.
Thanks,barat