How to get the date(dd) of every monday

Help
1

Hi Team,

I want to get the date of every monday all the year. Could you please let me know how to get that?

E.g In february - all monday dates are 3, 10, 17, 24

Thanks,
Ula

1 Like
2

@Boopathi This is the one thing I can think of as of now.

image
image992Ă—804 25.3 KB

3

Hi @Boopathi,

AllDatesInMonth(year, month).Where(i => i.DayOfWeek == DayOfWeek.Monday)

Following function will give you collection of dates that falls on Monday.

2 Likes
5

Didn’t know about that
Thanks, @Ragu9060

6

@MartianxSpace its a Linq query, this is similar to select queries.

If you need to learn more on Linq look into the below link.

2 Likes
7

@Ragu9060 Can we use that query as it is Directly in UiPath, by assigning it to a variable?

8

@supermanPunch please provide more details on your question.

9

@Ragu9060 The Linq Query you Suggested , how do i use it?

1 Like
10

@supermanPunch simply use a assign activity, pass your linq query to right side of assign activity. To the left create a variable, linq query returns a collection of data so create a variable with data type related to collection like arrays.

11

@Ragu9060 “AllDatesInMonth” is it a variable?

12

Its a function @MartianxSpace

13

@Ragu9060 I mean I know a bit of Linq Query :sweat_smile:, My Question was in the Query :
AllDatesInMonth(year, month).Where(i => i.DayOfWeek == DayOfWeek.Monday)

We can’t use => operator in terms of UiPath

14

@Ragu9060 I am not able to use this funtion

15

DateTime.DaysInMonth(year,month)

Try using this instead of AllDatesInMonth

1 Like
16

@Ragu9060 I got it now, I was confused for a bit :sweat_smile:

17

@Ragu9060 But Still not able to Use Where condition with it :sweat_smile:

18

Actually DaysInMonth will return a int which is the count of days in the month. Try to convert the count into collection then it will work.

19

@MartianxSpace Can you share the workflow you created ?

20

@supermanPunch Here is the XAML file
Main.xaml (6.7 KB)

21

@supermanPunch Need to add few things so it can work irrespective of any day. I am working on it.