Date format conversion while reading from excel

Help
1

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 !

2

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"));
3

Hi,

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

4

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

5

The date shown is the Excel Serial Date

Try Datetime.FromOADate(myDate).ToShortDateString

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

1 Like