How to convert a value in double to DateTime Format?

Help
, ,
1

Hello,
NOTE: [URGENT]
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

2

Hi,

Did you resolved this? can you share solution?

3

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

3 Likes
4

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