How to convert Date in Excel to Generic Value and Format the value?

[audrxyx]

I want to convert Date in Excel to Generic Value and format the value using the format value activity in UiPath but it gives me an error.

Help appreciated!

[NervYerem]

Do you have a screenshot of your workflow? That’ll show us the methods you’re using so we can suggest corrections or different methods

[Rahul_Unnikrishnan]

Hello @audrxyx
If you get the value from excel it will be in the string format. SO in order to change the date format you need to convert that to datetime. You can check the below video for the conversion.

How to Convert String to DateTime in UiPath?| Methods of conversion| Practical demo & Tutorial

[muhammedyuzuak]

Hi @audrxyx,

Can you share the error? If you are using Globalization.CultureInfo.InvariantCulture add System.Globalization in imports.

Regards,
MY

[ushu (Usha kiranmai)]

@audrxyx Can you explain how you are trying to achieve this and also what is the error that you are getting