UiPath | First Working Day | Last Working Day | Total Working Day | Working Days using LINQ

[@suraj_singh321]

Hii Mahmoud sir make a video on power function example I am taking input from user as 3 and I want to do a square of it in PAD

[@suraj_singh321]

Hii Mahmoud sir make a video on terminal emulation in Power automate desktop why and where it is used

[@ActAutomate]

I will try Suraj, but not very soon :-(

[@UiPathUser]

hi Mahmoud. There are not enough videos about SOAP calls. Can you please make one step by step video about SOAP calls and parsing xml that has namespaces in it?

[@ActAutomate]

Sure I will try to do that asap ;-)

[@Saleem143145]

Hi bro, in my case I need to add 2 business days to for a specific date, which should exclude sat, sun, and holidays (excel file)...can u help me?

[@ActAutomate]

Do you want to add the next two working days to the given date? Must be in the same month or is it ok to be only the next two days, no matter if they are in the same month or in the next month?!

[@Saleem143145]

@@ActAutomate @Act Automate (Mahmoud TV) I am extracting date from one web page, for that date I need add expected delivery date as 2 dates excluding sat,sun,holidays...The date might be end of the month also...For ex: The extracted date is 31/03/2023, if 1/4, 2/4 is sat, sun, and 3/4 is holiday...then I need to add 4/4+5/4 dates ...that means my expect date of delivery is 05/04/2023...

[@ActAutomate]

@@Saleem143145 You can do that in very similar way like in the video. For example the following sequence: StartDate = New Date (Year,Month,Day) EndDate = New Date (Year,Month+1,Day) AllMonthDays = Enumerable.Range(1, (EndDate - StartDate).Days + 1).Select(Function(x) StartDate.AddDays(x)).ToArray SecondWorkingDay = ( From d In AllMonthDays Where d.DayOfWeek DayOfWeek.Saturday AndAlso d.DayOfWeek DayOfWeek.Sunday Select d ).Skip(1).First() The output of SecondWorkingDay is the date you need, which is the second working day after the given date. I used the following variables with values to test: Day = 16 Month = 3 Year = 2023 The output was: 20.03.2023, which is a Monday, and it's the second working day after the given date which is 16.03.2023 You only have to add a check for holidays as I mentioned in the video. please let me know, if you still need help 🙂

[@Saleem143145]

@@ActAutomate thanks, I will check this...thank u very much

[@Saleem143145]

Subscribed ur channel

[@suraj_singh321]

Make a video on power automate desktop odd even no prime no Fibonacci series Armstrong no to develop the logic as it not easy as uipath to understand

[@ActAutomate]

Sure Suraj, I already did it, but I need time to edit the videos and publish them. Just wait for that!

[@suraj_singh321]

Hi sir are you busy when you will be back uploading videos 😑

[@ActAutomate]

Hi Suraj, I will be back in 2 Weeks.

[@aparnakrishnan5465]

Very helpful content 😊

[@ActAutomate]

Thanks Aparna 😊