I am copying dates from spreadsheet 1 into spreadsheet 2. When I parse the dates I am using:
DateTime.ParseExact(row(“Remittance Sent”).ToString,“MM/dd/yyyy HH:mm:ss”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)
It copies the dates over, however when it parses the dates it is converting them incorrectly,
i.e in the Spreadsheet 1 the date is 01/02/2020 however when parsing it is writing out the dates in Spreadsheet 2 as 02/01/2020 (using the American format, not what I want)
I have tried many different things and am having no luck.