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,