MarketplaceStudioSnippetBusiness Day Calculator

Create your first automation in just a few minutes.Try Studio Web

Business Day Calculator

Business Day Calculator

by Internal Labs

3

Snippet

Downloads

904

John Krönander
Posted 5 years ago

Hi!

I've just start working with RPA and one of my first task is to fix an already existing RPA.

What I need to fix is related to calculation of previous working day.

My factory is located in Sweden and we both have public holidays and other "non-working" days to take in to account.

This seems to be managed by using the condition in your snippets:

in_HolidayList.Contains(out_WorkDay.Date).

We have an Excel file with all public holidays and "non-working" days which is updated frequently.

Could this be used to populate the "HolidayList"?

Or how could I best populate the "HolidayList" with the "non-working" days?

Thank you in advance!

BR//

John

Kristie Choe
Posted 5 years ago

Hi is it possible to create the HolidayList to be dynamic so that the federal paid holidays can be accounted for future years past 2020? (i.e., 1/1 is always New Years, last Monday of May is always Memorial Day)

hiro take
Posted 6 years ago

はじめまして!

こちらのコンポーネントの使いかたを説明した動画等はございますでしょうか?

現在、StudioのSnippetsへXamlをInstallするところまで、出来ています。

出来ていないところは、

引数でどのように値を入れていけばいいのかが分からないです。

お手数お掛けいたしますが、よろしくお願いいたします。

Mihai Popescu
Posted 5 years ago ago

Hello.

Here are 2 examples:

  1. How to obtain a DateTime variable with a future day 6 days in the future taking into account that the day of 26th September is a Holiday. Click HERE to see the picture
  2. How to obtain a DateTime variable with a business day 6 days in the future taking into account that the day of 26th September is a Holiday. Click HERE to see the picture

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.1

Updated

February 18, 2020

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Support

UiPath Community Support