UiPathTeam.Calendar.Activities


#1

Calendar activities packages will contain two activities, one to get holiday list from specified date range and the other one to calculate the next N days business date given a start date.
Holiday data will be stored in local since most of the client environments have the internet access restriction. It would be more reliable to retrieve the local data. The supported date ranges from year 1995 to 2034

1.Get Public Holiday Activity
Input: FromDate, ToDate, CountryCd
Output: Hoiday List (List of dictionaries each of which contains three key pair values: “YMD”,“Weekday”,“Description”)

2.Business Day Calculator
Input: CountryCd(e.g. “JP”), Start(e.g.2018-05-02), Days(e.g. 13, use negative number to indicate past day)
Output: Target(e.g.2018-05-13)

Package: UiPathTeam.Calendar.Activities
Author: @calvin.he


#2

Can you provide an example of how this works? Thanks.


#3

I have uploaded a example workflow using the calendar activity.
Main.xaml (8.7 KB)


#4

Thank you very much. Where are you pulling this data from? Are you planning to add more countries?


#5

Great Job.

Any Idea of where to get the list Holidays for UK, IRL and DE?


#6

Use visual studio and nager library.

case closed :wink:


#7

I don’t have uipath calender packages in 2018.1 version. Is there ay other way to find next business day .

Pleae suggest some approach.
Thanks


#8

Please down the latest installer


#9

Hi can we get all Business dates in between of a date range(startDate and EndData) by using calender?


#10

hello all,
is there any way to get list/array of dates in between a date range(like 01-01-2017 to current date)

expected output will be
date_list = [‘02-01-2017’,’ 03-01-2017’, ‘04-01-2017’,…………………………‘07-09-2018’]


#11

Hi,
first of all, great job!
Is there any way to get the Holidays for other countries?


#12

I am using the calendar package now. one issue i faced like below.

i want setting my own company holiday day like “2017.12.31 ~ 2018.1.3”, after that when using “Business day calculator”, package can skip it automatically and give the correct business day back.

Wish this functionality could be add into package in the future:star_struck:.


#13

Hi,

Please excuse the stupid question. I downloaded the calendar.activities package and tried to run @calvin.he example workflow using “GB” instead of “JP”.

I get the following error message

image

Are the holiday files not loaded when you install the package? If so how do you get them couldn’t see anything on the nager website about installing holiday csv files

OK so in the folder are CA JP and US holidays If I can make a GB one I should be OK.

I’m trying to make my own GB calendar in the hope that the calendar activity will just work for GB once the calendar file has been created.

One problem is that the first 3 columns are Year Month Day, the next one is, I don’t know (it’s probably obviously but I just don’t know what that column is) Can anyone let me know what that represents and is it important for the function to work.

This is an example from the US holidays csv file

image

What does that 4th column number represent?


#14

Looks like the day of the week. So 1 = Monday, 2 = Tuesday etcetera.


#15

@evangemart you are a genius! (and I’m an idiot! of course you are correct)