I’m trying to convert a date value into “dd-MM-yyyy” format using Convert.ToDateTime(InvoiceDate).ToString(“dd-MM-yyyy”) and store it in excel. I’m able to convert the data successfully. However for few dates are stored as normal number. PFA. Highlighted invoice number and respective date in ACME and my output sheet.
Request you to please check and advice.