How to get a sheet name and convert it a datetime format?

[makboga]

Hi,
I have an excel sheet named like 03.11.2022 I want to take this name as datetime and write to first and last day of this date in a webpage.
For example if the sheet name is 03.11.2022 then I want to write 01.11.2022 and 30.11.2022.
Thank you.

[Rahul_Unnikrishnan]

Hello @makboga

You can use the Getsheet method to get the sheetnames. Please check the below psot. Then to get the first date of the month, you can use the modify date activity.

How to get the Sheet Names of an Excel File in UiPath - RPA Learners

How to Modify Date in UiPath? Modify Date activity explained with demo

[Anil_G (Anil Gorthi)]

Hi @makboga

After doing get sheets you will have sheet name

Now for first date use “01.” + date.ParseExact(“yourdate”,”dd.MM.yyyy”,system.globalization.culturalinfo.invariantculture).tostring(“MM.yyyy”)

For last date daysinmonth(Cint(yourdate.split(“.”c)(1)), Cint(yourdate.split(“.”c)(2)))+ date.ParseExact(“yourdate”,”dd.MM.yyyy”,system.globalization.culturalinfo.invariantculture).tostring(“MM.yyyy”)

Cheers

[makboga]

I used get sheets and get the sheet name but when I convert sheetname to datetime it gives me US format as 11.03.2022 but I want European format. How can I fix this?

[Gokul001 (Gokul Balaji)]

HI @makboga

How about this expression?

Get Only the Month from the Input

DateTime.ParseExact(yourString,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM")

First Date

New DateTime(Now.Year,CInt(GetMonth),1).ToString("dd-MM-yyyy")

Last Date

New DateTime(Now.Year,CInt(GetMonth)+1,1).AddDays(-1).ToString("dd-MM-yyyy")

Check out the XAML file

FirstandLastDate.xaml (6.3 KB)

Regards
Gokul

[makboga]

I am getting this error

[Gokul001 (Gokul Balaji)]

Hi @makboga

Have you check my XAML file.

You have to Declare the GetMonth

Check out the Screenshot

[makboga]

It worked thank you so much.