UiPath | First Working Day | Last Working Day | Total Working Day | Working Days using LINQ
#rpa #uipath #linq
👉 𝐄𝐧𝐠𝐥𝐢𝐬𝐡
● This video is about calculating💻𝗪𝗼𝗿𝗸𝗶𝗻𝗴 𝗗𝗮𝘆𝘀 using 𝗟𝗜𝗡𝗤🔥
● You will learn the following points:
→ How to calculate the 𝗙𝗶𝗿𝘀𝘁 𝗪𝗼𝗿𝗸𝗶𝗻𝗴 𝗗𝗮𝘆 of a month?
→ How to calculate the 𝗟𝗮𝘀𝘁 𝗪𝗼𝗿𝗸𝗶𝗻𝗴 𝗗𝗮𝘆 of a month?
→ How to calculate the 𝗧𝗼𝘁𝗮𝗹 𝗪𝗼𝗿𝗸𝗶𝗻𝗴 𝗗𝗮𝘆𝘀 of a month?
→ How to calculate specific working days of a month?
🌟 𝗖𝗼𝗱𝗲
✔ Month = 1
✔ Year = 2023
✔ StartDate = New Date(Year, Month, 1)
✔ EndDate = New Date(Year, Month, Date.DaysInMonth(Year,Month))
✔ Days = Enumerable.Range(0, (EndDate-StartDate).Days+1).Select(Function(x) StartDate.AddDays(x)).ToArray
🕜 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
► 00:00 Introduction
► 00:21 Define variables
► 01:08 Month | Year | StartDate | EndDate
► 02:16 Calculate Days of the month
► 03:12 First Working Day
► 04:02 Last Working Day
► 04:16 Total Working Days
► 04:34 Display Results
► 05:44 Execute Process
► 06:54 Calculate Holidays
► 07:37 Third Working Day
► 07:49 First 5 Working Days
► 07:58 Last 3 Working Days
📝 𝗟𝗜𝗡𝗤 𝗩𝗶𝗱𝗲𝗼𝘀
𝗔. 𝗣𝗔𝗥𝗧𝗜𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗧𝗔𝗞𝗘: • UiPath | TAKE Function - LINQ | LINQ Tutor...
➋ 𝗦𝗞𝗜𝗣: • UiPath | SKIP Function - LINQ | LINQ Tutor...
➌ 𝗧𝗔𝗞𝗘𝗪𝗛𝗜𝗟𝗘: • UiPath | TAKEWHILE Function - LINQ | LINQ ...
➍ 𝗦𝗞𝗜𝗣𝗪𝗛𝗜𝗟𝗘: • UiPath | SKIPWHILE Function - LINQ | LINQ ...
➎ 𝗧𝗮𝗸𝗲𝗟𝗮𝘀𝘁: • UiPath | TakeLast Operator - LINQ | LINQ T...
➏ 𝗦𝗸𝗶𝗽𝗟𝗮𝘀𝘁: • UiPath | SkipLast Operator - LINQ | LINQ T...
𝗕. 𝗣𝗥𝗢𝗝𝗘𝗖𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗦𝗘𝗟𝗘𝗖𝗧: • UiPath | SELECT Function - LINQ | LINQ Tut...
➋ 𝗦𝗘𝗟𝗘𝗖𝗧𝗠𝗔𝗡𝗬: • UiPath | SELECTMANY Function - LINQ | LINQ...
𝗖. 𝗙𝗜𝗟𝗧𝗘𝗥𝗜𝗡𝗚 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗪𝗛𝗘𝗥𝗘: • UiPath | WHERE Function - LINQ | LINQ Tuto...
➋ 𝗢𝗳𝗧𝘆𝗽𝗲: • UiPath | OfType Operator - LINQ | LINQ Tut...
➌ 𝗦𝗲𝗾𝘂𝗲𝗻𝗰𝗲𝗘𝗾𝘂𝗮𝗹: • UiPath | SequenceEqual Operator - LINQ | L...
𝗗. 𝗤𝗨𝗔𝗡𝗧𝗜𝗙𝗜𝗘𝗥 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗔𝗟𝗟: • UiPath | ALL Function - LINQ | LINQ Tutori...
➋ 𝗔𝗡𝗬: • UiPath | ANY Function - LINQ | LINQ Tutori...
𝗘. 𝗘𝗟𝗘𝗠𝗘𝗡𝗧 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗘𝗹𝗲𝗺𝗲𝗻𝘁𝗔𝘁: • UiPath | ElementAt Operator | ElementAtOrD...
➋ 𝗘𝗹𝗲𝗺𝗲𝗻𝘁𝗔𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁: • UiPath | ElementAt Operator | ElementAtOrD...
➌ 𝗙𝗶𝗿𝘀𝘁: • UiPath | First Operator | FirstOrDefault O...
➍ 𝗙𝗶𝗿𝘀𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁: • UiPath | First Operator | FirstOrDefault O...
➎ 𝗟𝗮𝘀𝘁: • UiPath | Last Operator | LastOrDefault Ope...
➏ 𝗟𝗮𝘀𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁: • UiPath | Last Operator | LastOrDefault Ope...
➐ 𝗦𝗶𝗻𝗴𝗹𝗲: • UiPath | Single Operator | SingleOrDefault...
➑ 𝗦𝗶𝗻𝗴𝗹𝗲𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁: • UiPath | Single Operator | SingleOrDefault...
➒ 𝗗𝗲𝗳𝗮𝘂𝗹𝘁𝗜𝗳𝗘𝗺𝗽𝘁𝘆: • UiPath | DefaultIfEmpty Operator | LINQ Tu...
𝗙. 𝗚𝗘𝗡𝗘𝗥𝗔𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗥𝗮𝗻𝗴𝗲: • UiPath | Range Operator - LINQ | LINQ Tuto...
📝 𝐏𝐫𝐨𝐜𝐞𝐝𝐮𝐫𝐞
➊ Assign Month
➋ Assign Year
➌ Assign StartDate
➍ Assign EndDate
➎ Assign Days
➏ Assign FirstWorkingDay
➐ Assign LastWorkingDay
➑ Assign TotalWorkingDays
➒ Print out the results
✍ 𝗞𝗲𝘆 𝗪𝗼𝗿𝗱𝘀
→ UiPath
→ UiPath Automation
→ UiPath Activity
→ Calculate working days in UiPath
→ Calculate working days using LINQ
→ Get first working day
→ Get last working day
→ Get total working days
→ Get third working day
→ Get first 5 working days
→ Get last 3 working days
→ LINQ Tutorials
→ LINQ in UiPath
→ LINQ Query
𝗙𝗼𝗹𝗹𝗼𝘄 𝘂𝘀
📰 𝗙𝗮𝗰𝗲𝗯𝗼𝗼𝗸 𝗣𝗮𝗴𝗲: / actautomate
📌 𝗙𝗮𝗰𝗲𝗯𝗼𝗼𝗸 𝗚𝗿𝗼𝘂𝗽: / 3241715929443302
💼 𝗟𝗶𝗻𝗸𝗲𝗱𝗜𝗻: / 70939125
📸 𝗜𝗻𝘀𝘁𝗮𝗴𝗿𝗮𝗺: / actautomate
🔥 𝗣𝗮𝘁𝗿𝗲𝗼𝗻: / actautomate
🤖 𝗬𝗼𝘂𝗧𝘂𝗯𝗲: / @actautomate
📢 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 𝗦𝗵𝗼𝗿𝘁𝘀: / @actautomateshorts
👍 𝗦𝘂𝗯𝘀𝗰𝗿𝗶𝗯𝗲: / @actautomate