Dynamic date of month

Learning Initatives Reboot Your Skills 2021
1

Hi can u help me please
I want to write all the dates from the first day of the month to the last day of the month.
1.06.2021

31.06.2021
and the robot should be able to do this for all months

2

@sedayngl_sedayngl33 _ here you go… I will give you the steps…so that you can easily try yourself…

image
image1344×641 32.8 KB 

StartDate = Convert.ToDateTime(New DateTime(Now.Year, Now.Month, 1))

endDate = Convert.ToDateTime(new DateTime(now.Year,now.Month+1, 1).AddDays(-1))

Here StartDate and EndDate are Datetime variables…

image

For Each Loop

Type Argument is System.Datetime

Enumerable.Range(0, 1 + endDate.Subtract(startDate).Days).Select(Function(x) startdate.AddDays(x)).ToArray()

Write Line

item.tostring("d.M.yyyy")

Output

image
image240×596 2.5 KB

image

BTW: There is no 31st in June :wink:

Hope this helps…

3

read the solution on this link

you can implement the same in uipath usig the linq query.

image
image780×62 3.59 KB

Enumerable.Range(1, Date.DaysInMonth(2021, 06)).Select(function (d) New Date(2021, 06, d).ToString("d.M.yyyy")).ToList

1 Like
4

To Make it dynamic as per the @sedayngl_sedayngl33 request…

Enumerable.Range(1, Date.DaysInMonth(now.Year, now.Month)).Select(function (d) New Date(now.Year, now.Month, d).ToString("d.M.yyyy")).ToList
1 Like
5

Thank u ıt worked

6

thank u ıt worked

1 Like
7

Hi
New question ı want to all each date row
B1 cell contaıns 1.06.2021 C1 cell contaıns 2.06.2021 D1 cell contains 3.06.2021…end of month

8

Hi
New question ı want to all each date row
B1 cell contaıns 1.06.2021 C1 cell contaıns 2.06.2021 D1 cell contains 3.06.2021…end of month

9

Date Row.xaml (7.9 KB)

1 Like
10

THANK YOU IT WORKED

11

please mark it as a solution

13

Hello
I want to dedicate all the days of a month to seven days the robot should be do thıs for all month

14

I am unable to understand your problem statement

15

That is, for example
1.06.2021 …08.06.2021 first week
2.06.2021 …09.06.2021 second week or 2.04.2021 … 9.04.2021 first week
first day able change…

16

Send me sample output excel file

17

Hi
Can u help me please ı have an excel sheet B6 cell ıncludes “vegetables” ı want to output B6 that is cell name?

18

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