Hello, I Have a value I read out my excel I need to parse to a datetime value. Datum = Date.ParseExact(row.item(5).ToString,“dd/MM/yyyy”,CultureInfo.InvariantCulture) datum is a datetime variable. But i get the error: String was not recognized as a valid DateTime. any idea how to solve this?

DatetoString.xaml (5.1 KB) Hi @seldo I have one string varibale having datetime and i am converting it into Date time variable. please find the attached xaml for reference. Thanks Latika

Parse string to datetime error

Help

Lakshay_Verma (Lakshay Verma) June 24, 2020, 7:11am 4

@seldo
Just try printing row.item(5).tostring in output pane using write line and share results please

Convert String To Datet

Topic		Replies	Views
!String was not recognized as a valid DateTime Help activities , error , variable , string	10	4650	January 8, 2020
String was not recognized as a valid DateTime error even after using DateTime.ParseExact Activities excel , variable	10	5025	March 17, 2022
Cannot convert string to datetime Help	9	5328	December 8, 2018
Datetime.ParseExact : String was not recognized as a valid DateTime Studio studio , string , question	12	7703	November 26, 2020
String was not recognized as a valid DateTime - Why this error is coming suddenly? Activities excel , activities , question	14	1083	December 1, 2023

Parse string to datetime error

Related topics