Date format conversion while reading from excel

Hi,

I am using a Vlook up formula inside excel sheet to derive a date in a particular cell.

It appears in the proper date format inside excel. But while reading the value in uipath i could see the date to be in 5 digit numeric format…

for eg: today’s date is represented as 43755

Any idea as to how to get it in date format?

Thanks !

Try something like this when you collect your data, it will convert it to the country you need

Examples for countries:

 myDate.ToString(new CultureInfo("en-US"));
myDate.ToString(new CultureInfo("en-GB"));

Hi,

I tried and still got the error “: Exception in Main: System.FormatException: String was not recognized as a valid DateTime”

Is it in the “Date” type in the excel? or Genereal type?

The date shown is the Excel Serial Date

Try Datetime.FromOADate(myDate).ToShortDateString

mydate should be numerical value (i.e. Double Type)