How to validate today is working day or not?

Dorothy_lee · March 25, 2021, 6:29am

Hello, all

I’d like to validate that today is working day or not.
After that I’ll use the output result with IF condition.
If Tuesday is working day , it should calculate last Tues to Mon. Otherwise, it has to set last Tues to Sun.
Could you please help for validating working day value?
Region: KR and Robot will be running every Tues.

ManiPrajwal_K · March 25, 2021, 7:00am

If you’re looking normal calendar… then I guess so Saturday and Sunday are the non working days.

Then to find the current day you can use this simple method Now.ToString("dddd") - It returns the current day, then you can evaluate if the output is not Sat & Sunday then you’re good to go!

NIVED_NAMBIAR · March 25, 2021, 7:04am

Inaddition to what @ManiPrajwal_K said

you can try this in if condition

Now.DayOfWeek.ToString<>“Sunday” Or Now.DayOfWeek.ToString<> "Saturday"

Regards,
Nived N
Happy Automation

AdityaVN · March 25, 2021, 7:10am

I’ve attached a small sequence to find out if Today is holiday.
Details of the Sequence:
Holiday is an array of Strings which holds the week days that are holidays eg:Sunday,Saturday
CheckDay is a Str var to hold today’s week of the day

hope this is helpful

you can manipulate the holidays based on the strings in the array Holiday

Main.xaml (5.4 KB)

Dorothy_lee · March 25, 2021, 7:39am

@NIVED_NAMBIAR Thank you for your reply!
By the way, it has to identify KR public holiday… which is non-business day.
Can it be possible?
It doesn’t have to verify Sun or Sat. Sorry for lack of information

NIVED_NAMBIAR · March 25, 2021, 7:41am

hi @Dorothy_lee
what u mean by KR public holiday ?

Dorothy_lee · March 25, 2021, 7:43am

@NIVED_NAMBIAR kind of this date.
ttps://www.officeholidays.com/countries/south-korea/2021

AdityaVN · March 25, 2021, 7:54am

to identify holidays other than wkends we need to maintain holiday list (in excel/notepad) and refer it back to check if that list has today’s date.

NIVED_NAMBIAR · March 25, 2021, 7:56am

Hi @Dorothy_lee

Just got with the @AdityaVN suggestion, scrape the holidays list from the website and using that manipulate whether the day is holiday or not

Regards,
Nived N
Happy Automation

Dorothy_lee · March 26, 2021, 7:30am

@AdityaVN @NIVED_NAMBIAR Thank you for providing alternative ways. I’ll try that way and update the result here

Jeroen_Van_Loon1 · March 26, 2021, 3:29pm

There is of course a lot of cultural bias here, defining what a working day is.
Mostly it is mon - fri, with exception of several national holidays.

So you need to do 2 checks:

is the day monday-friday (or not saturday-sunday, whichever is easiest). Achivable by the examples above on getting the workday as part of the date: MyDate.DayOfWeek retuns the specific weekday having MyDate as a date or datetime datatype.
is the specific date a non-working holiday. You might be able to scrape this from some website, but that leaves your process with an external dependency on that site. I’d avoid that myself. I would probably set some asset or a small text- or excelfile with a list of holidays to validate against.

So is my date a basic workday and not in my exceptionlist → then it is a workingday.

Dorothy_lee · March 26, 2021, 11:37pm

@NIVED_NAMBIAR @AdityaVN Hello, I found that local custom activity which is getting data from Korea National Official data website API.
But it’s output data type is Dictionary so it cause below error. Is there any way that I can resolve this issue?

AndresTarazona · March 27, 2021, 2:27am

Hi @Dorothy_lee

Can you take a look to this document
Calendars Requests (uipath.com)

You can define your own Calendar on the UiPath Orchestrator, get it from your robot and compare if the date you are evaluating is one of the ExcludedDates by using the Orchestrator API.

Pros: You can set the dates your company/organization defines as non working days and update them directly on the Orchestrator.

Cons: You have to set manually all the non working days. The good part it is you can import a calendar as csv to create the UiPath calendar.

Bests,
Andres

AdityaVN · April 4, 2021, 12:49pm

Hi

Dictionary can be manipulated to your requirement. But my suggestion is to avoid API calls unless it is absolutely necessary as this will add time to the process.

Instead you can have all the holidays in excel like below (Indian Holiday list), read it as a DataTable,
iterate through each row
add only the dates to a collection variable - you can use Add to Collection activity
check IF collection_var.Contatins(checkDay)

I’ve attached a sequence which check for working or holiday based on the dates in the excel present along with it. It can be invoked in your workflow by converting ‘CheckDay’ as input argument and ‘Result’ as output argument.

Let me know if this is helpful

WorkingORnot.zip (11.2 KB)

Dorothy_lee · April 4, 2021, 8:40am

Thank you so much for suggesting alternative ways but could you please attach ,xaml file again? I’m unable to open it.

Dorothy_lee · April 4, 2021, 12:48pm

Hello, I’ve just created based on your comment since I couldn’t open the file.
By the way, It seems like almost correct but when I test it the result is wrong. Could you please review where is wrong…?
This test file contains today date so, it should show " Holiday" but shows “No Holiday” comment

I’m wonder that which value should be input in item field?

AdityaVN · April 4, 2021, 3:03pm

Hi
yes you identified the reason correctly, Add to Collection will take two input arguments - one is the collections variable (List_Date) and other is holiday date.

Create a datetime var (tempdate)
assign tempdate = Convert.ToDateTime(row(0).ToString)
in Add to Collection properties assign tempdate to Item

attached the xaml.