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

Question

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:

Answer 1

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()”