I have extracted the date from excel and the format is “MM/dd/yyyy”
so i used
Date.ParseExact(“MM/dd/yyyy”,row(“Project Date”).ToString, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)
to change the format to “dd/MM/yyyy”
I still face error after typing this into the message box…
Main has thrown an exception
Message: String was not recognized as a valid DateTime.