String '1/6/2023' was not recognized as a valid DateTime

Help Activities
, , , , ,
1

I have a column with the information dd/MM/yyyy hh:mm:ss. I want to make parser to the dd/MM/yyyy

I have read range excel of the column date, the save to is vRange
I have for each row in data table , with for each CurrentRow
I have get row item with value vfecha
I have Assign DateTime.ParseExact(CurrentRow(“created_time”).ToString,“dd/MM/yyyy hh:mm:ss”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”) and the error is String ‘1/6/2023’ was not recognized as a valid DateTime

2

below this assign once the check the value of Currentrow("Created_time).tostring
and check the format of it it was like dd/MM/yyyy or d/M/yyyy
based on the above pass in in place of after CurrentRow(“created_time”).ToString
DateTime.ParseExact(CurrentRow(“created_time”).ToString,“dd/MM/yyyy ”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)
or you can use CDate(CurrentRow(“Created_time”).tostring inplace of CurrentRow("Created_time).tostring

3

Hi ,

Try this
DateTime.ParseExact(CurrentRow(“created_time”).ToString,“d/M/yyyy",System.Globalization.CultureInfo.InvariantCulture)

4

Hi @Julian_Torres_Torres

Assign vfecha = DateTime.ParseExact(CurrentRow(“created_time”).ToString, “d/M/yyyy hh:mm:ss”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Thanks!!