To get Date from Month

Help Studio
, ,
1

Hello guys i have a input dialog box to select Month

image
image1291Ă—442 28.7 KB
t

I want to get the starting and ending Date for the selected month.

2

@Gokul_Murali

for first day just add 1 and the year as you need

once you get that the first date use cdate(date).Addmonths(1).AddDays(-1).ToString("MM/dd/yyyy")

cheers

3

Hi @Gokul_Murali

Try this way

First convert → MMMM to MM

var string monthNumber = DateTime.ParseExact(monthName, "MMMM", System.Globalization.CultureInfo.InvariantCulture).ToString("MM")

var datetime startDate = New DateTime(selectedYear, selectedMonth, 1)

var datetime endDate = startDate.AddMonths(1).AddDays(-1)

Here selectedYear, and selectedMonth variable type is integer

Regards,
Gowtham K

4

Hi @Gokul_Murali

I have attached the workflow below,

Main.xaml (16.4 KB)

This image shows a sequence of activities in a UIPath workflow that assigns variables to get the first day of a specified month and outputs it using a Write Line activity. (Captioned by AI)
This image shows a sequence of activities in a UIPath workflow that assigns variables to get the first day of a specified month and outputs it using a Write Line activity. (Captioned by AI)1293Ă—805 31 KB

A screenshot from a computer showing a workflow sequence and output panel, likely from an automation or programming interface. (Captioned by AI)
A screenshot from a computer showing a workflow sequence and output panel, likely from an automation or programming interface. (Captioned by AI)872Ă—377 49.8 KB

5

@pradeep931

Bro this file showing invalid

6

@Gokul_Murali

Please check again, i have converted to zip

SelectedDate.zip (152.7 KB)

7

@pradeep931

image
image1012Ă—747 42.4 KB

Again it look invalid

8

Main.xaml (16.4 KB)
Could you please try this

9

@pradeep931

Again the same brother

10

HI,

Can you share what version of Studio you use?

Also, share information about which year we should use?

Regards,

11

@Yoichi

Studio version is 22.4.3

12

@Gowtham_K115

Here i have declared (monthNumber) variable.

In ( startDate) variable What is this selectedYear and selectedMonth variable

13

@Gokul_Murali

I’m not sure why you’re unable to access it, but I’ll provide the detailed steps I used in my code below. Please follow these steps in your XAML:

Assign str monthname = “September”
Assign int MonthNumber = CInt(DateTime.ParseExact(monthName, “MMMM”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM”))

Assign String
FirstDay = New DateTime(Now.Year,MonthNumber,1).Tostring(“MM/dd/yyyy”)

Assign int DayinMonth = datetime.DaysInMonth(now.Year,MonthNumber)

Assign String LastDay = New Date(now.Year, MonthNumber, daysInMonth).Tostring(“MM/dd/yyyy”)

Output FirstDay and LastDay

This image shows a sequence in UiPath Studio designed to get the first day of the month and write a line output with that date. (Captioned by AI)
This image shows a sequence in UiPath Studio designed to get the first day of the month and write a line output with that date. (Captioned by AI)1187Ă—822 39 KB

The image depicts a series of workflow steps and assignments in an automation script or tool, calculating and printing the first and last days of the current month. (Captioned by AI)
The image depicts a series of workflow steps and assignments in an automation script or tool, calculating and printing the first and last days of the current month. (Captioned by AI)987Ă—630 20.6 KB

14

Hi,

How about the following? This assumes it uses current year

Main.xaml (6.8 KB)

Regards,

15

@ Thank You guys

@Yoichi
@pradeep931
@Anil_G
@Gowtham_K115

1 Like
16

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