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.
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!
Inaddition to what @ManiPrajwal_K said
you can try this in if condition
Now.DayOfWeek.ToString<>“Sunday” Or Now.DayOfWeek.ToString<> “Saturday”
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)
@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
what u mean by KR public holiday ?
@NIVED_NAMBIAR kind of this date.
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.
Just got with the @AdityaVN suggestion, scrape the holidays list from the website and using that manipulate whether the day is holiday or not
@AdityaVN @NIVED_NAMBIAR Thank you for providing alternative ways. I’ll try that way and update the result here
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.
@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?
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.
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
Thank you so much for suggesting alternative ways but could you please attach ,xaml file again? I’m unable to open it.
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?
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.
WorkingORnot.xaml (12.9 KB)
Thank you for your kind reply. Is there any way that I can see your process?
And also, I found below error message when I added new Assign which is Tempdate
Holidays file is same file that you shared in advance
format is d-MMM(ex. 01-Jan)
Thank you so much !! I finally solve the issue
I added item(0)
Glad to know it is solved