I have an excel with date value but in general format, I want that to be converted to date value and replace it to same table, example the table has value like 43759 but when we convert it should be 03-14-2012.
I tried different methods like clone table and get type and add the value back to dt but didnt work, also tried below code but gives error.
DT= (From row In DT order by DateTime.FromOADate(row.item(Date).ToString(“MM/dd/yyyy”)) Select row).CopyToDataTable
Please let me know the correct way to do it.
Thank youSample_Datetime.xlsx (9.9 KB)