Hi everyone, I’m encountering an issue while trying to convert dates in different formats into a specific format (dd/MM/yyyy). I have dates in the following formats: 22/Oct/2024 06/22/2023 18.11.2023 When I attempt to convert them to the format 22/06/2024, I’m getting this error:Assign: String ‘…

Error: String '' was not recognized as a valid DateTime

Raymond_Hui (Raymond Hui) October 15, 2024, 9:31am 2

Could you try below script?

DateTime.ParseExact("06/22/2023", "MM/dd/yyyy", CultureInfo.InvariantCulture)

Topic		Replies	Views
Error: String was not recognized as a valid DateTime : Issue in getting the correct Format Studio excel , activities , studio , datetime-linq	5	4862	March 24, 2022
Assign String was not recognized as a valid DateTime Studio	5	429	October 28, 2023
Assign: String was not recognized as a valid DateTime Help	8	8184	January 20, 2021
String is not recognized as a valid datetime - MM/dd/yyyy format is only working Studio activities , studio , question , date , datetime	9	12162	April 18, 2022
Datetime convert error Activities database , activities , question	5	475	September 6, 2023