Lets take any date and find the Sunday date of that week using uipath?

Help Studio
, ,
1

Lets take any date and find the Sunday date of that week using uipath?
Can someone help me with the solution ?

1 Like
2

Hey @Koteswara_Rao

Here you go. Kindly check the below…

nmnithinkrishna_FindSundayFromDate.zip (2.1 KB)

Hope this helps

Thanks
#nK

3

grafik
YourDateTimeVar.AddDays(-{0,1,2,3,4,5,6}(YourDateTimeVar.DayOfWeek))

with the assumption on Sunday it will be the same Sunday (lookingback)
in case of looking forward or other offset we just modify if we want to add or substract and the weekday corrections

{0,1,2,3,4,5,6} - So,Mo,tu,we,th,fr,sa

Looking forward:
grafik

And can compact it (looking back, looking forward)
grafik

4

Lets take the date as 16th Feb 2022 (Format: 17/02/2022) and we have to find the next sunday date of that week using uipath ?

5

Lets take the date as 16th Feb 2022 (Format: 17/02/2022) and we have to find the next sunday date of that week using uipath ?

1 Like
6

Hey @Koteswara_Rao

Just add +7 in our message box in the above project I have shared.

That should help

Thanks
#nK

7

as mentioned above

grafik

 testDate
 [02/16/2022 00:00:00]
 testDate.AddDays(7 - testDate.DayOfWeek)
 [02/20/2022 00:00:00]

parsing a string with this format into a dateTime we do use
grafik

8

Is it possible to place a jpg screenshot and PDF file in new sheet of excel using UiPath ?
Please help me with some solutions. Thanks

9

@Koteswara_Rao
we prefer that a topic is scoped to 1 case. This allows others easier to find a solution in their similar cases.

This topic was about getting next sunday. When it was solved, then close the topic as described here:

Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

For the other question, feel free to open a new topic.

Thanks for support

10

thanks a lot @ppr

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.