How to read Month and Select Start & End Date from a Calender in Uipath?

0 votes

Hi Guys, I have an excel file containing only Month information and I want to select Start and End date of that Month from the web interface. Please kindly advice. Here I am attaching the screenshot:

image

Oct 23, 2019 in RPA by Apeksha
• 1,110 points
1,062 views

1 answer to this question.

0 votes

Hello Apeksha, If you need start date of a month, then the below line will help:

New DateTime(Now.Year, Now.Month, 1)

Hold its output to a datetime variable named startDate,and the following line will help you to get the last date of the month

startDate.AddMonths(1).AddDays(-1)

You need to pass Year, Month as integer so that you will get the desired value and store this value in endDate variable. Also make sure, you need to convert startDate and endDate variable type to System.DateTime datatype. And inside the Type Into Input, you need to pass “startDate.AddMonths(1).AddDays(-1).ToString()

answered Oct 23, 2019 by Anvi
• 14,010 points

Related Questions In RPA

0 votes
1 answer
0 votes
1 answer

How to read data from a excel, based on that data, check in the corresponding checkbox in browser appln? Uipath

Hi, to achieve this, you can perform ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 27,800 points
395 views
0 votes
1 answer

How to connect to a database from UiPath and read data from it?

Hi Pratibha, to connect to a database ...READ MORE

answered Oct 16, 2019 in RPA by Abha
• 27,800 points
1,119 views
0 votes
1 answer

Identify a Column in a database in UiPath Studio

There are two options to identify a ...READ MORE

answered Feb 11, 2019 in RPA by Sahiti
• 6,290 points
938 views
0 votes
1 answer

Which edition of UiPath is more suitable for individual use, Enterprise Platform or Community Edition? Why?

UiPath’s Community Edition (CE) is the version which is ...READ MORE

answered Mar 7, 2019 in RPA by Mishti
• 480 points
600 views
0 votes
1 answer

Write multiple line message using message box

@Rashmi Message Box activity in UiPath does ...READ MORE

answered Mar 4, 2019 in RPA by Abha
• 27,800 points
2,379 views
0 votes
1 answer

How to connect to MySQL database using UiPath?

Follow these simple steps to connect to ...READ MORE

answered Mar 7, 2019 in RPA by Mishti
• 480 points
3,783 views
+3 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8, 2019 in RPA by Anvi
• 14,010 points
9,040 views
0 votes
1 answer

What are Packages in UiPath Orchestrator and how can I manually upload a package to Orchestrator?

Hey @Erik, The Packages page displays all the ...READ MORE

answered Apr 5, 2019 in RPA by Anvi
• 14,010 points
2,842 views