How to change date in right format for column of excel using uipath

Help Studio
1

I want to copy date from one column of excel sheet and paste into another column of excel sheet. The original date is"13-Jan-21" format required format is “JAN-13”. and this change has to apply for entire column. I tried
PO_date = DateTime.ParseExact(gtdate,“dd-MMM-yy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMM-dd”) but getting error 'Option strict On disallows implicit conversions from Date to string.

1 Like
2

Hello, and welcome to the forum!

It seems that the type of gtdate is Date and not String. So this should be enough:

gtdate.ToString("MMM-dd")

Best,
Charbel

3

HI @Kanchan_Gawande

You can try this use change cell type of Bale Reva excel activities

image
image1518×696 31.6 KB

Give your cell range
And give your format

Regards
Sudharsan

1 Like
4

hi Charbel

I tried that but it doesn’t work

5

Hi @Kanchan_Gawande ,

Input parameter for dateTime.ParseExact is string so we have to provide datefprmat in string. As per your post we understood that the gtdate is date type. Could you try like below and let us know. Thanks.

PO_date = DateTime.ParseExact(gtdate.tostring,“dd-MMM-yy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMM-dd”)

And also refer the below documentation which is having different methods to convert date format to desired format. Thanks.

6

Hi @Kanchan_Gawande

To do the entire column, you have applied like this.

image
image1883×896 58.6 KB

Thank you @Sudharsan_Ka

Regards
Balamurugan.s

1 Like
7

Thanks for you @balupad14 it’s super helpful

Regards
Sudharsan

1 Like
8

Thank you sir it is very helpful

1 Like
9

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