How to convert a value in double to DateTime Format?

I have an excel which has a column called “Date” and its fixed with Date format of (dd-MM-yy)
I used read range activity to read the excel and
“DataTableName”.Rows(“rowNumber”).Item(“ColumnName”) to retrieve the data and Unfortunately it retrieved the date in DOUBLE value and not in the Date format.
What shall I do to get it in the date format of (dd-MM)?
Please help me out!

Thanks and regards,
Shreyas Shete


Did you resolved this? can you share solution?

You can use DateTime.FromOADate method. It returns you a Date Time variables.
You can get more info about this method from this link.

1 Like

Yeah I got this from same account… thanks :slight_smile: