HI, am reading data from excel to datatable, but the date will show as below.
- Tried using the below method to convert the format, but it become as string and written back to excel it become not filterable as data but as string. Is a simple to convert the date format and remain as date when written back to excel?
Convert.ToDateTime(Cdbl(item(“Valuation Date”))).ToString(“dd/MM/yyyy”)
Date
44652
44653