Skip to main content
P
preetis0002
September 3, 2021
Question

Calculation of Business Day from a Date

  • September 3, 2021
  • 3 replies
  • 0 views

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

3 replies

gayathris111098
gayathris111098
September 3, 2021

try this function networkdays() 

Also can you give some sample input and output?

    P
    preetis0002Author
    September 3, 2021

    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.

    B
    baratc
    September 5, 2021

    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

    Terms & ConditionsAccessibility statement