I am capturing data from an Excel file, the format I receive is dd.MM.yyyy, but when I try to convert it to DateTime it tells me that the format is not correct. What happens is that it interprets it as MM.dd.yyyy and as long as the dates are type 01.01.2024 or 07.02.2024 there is no problem, but wh…

Hi @Antonio_Perez I think you have two date formats i.e. dd.MM.yyyy and MM.dd.yyyy. Try the below syntax: DateTime.ParseExact(CurrentRow(1).ToString,{"dd.MM.yyyy","MM.dd.yyyy"},System.GLobalization.CultureInfo.InvariantCulture,DateTimeStyles.None).ToString("dd/MM/yyyy") Hope it helps!!

Change Format DateTime

Help Studio

ppr (Peter Preuss) February 22, 2024, 5:27pm 2

Topic		Replies	Views
Help required to change date format Studio studiox , question	11	2896	March 6, 2021
Date formatting problem Help studio	3	811	January 16, 2021
Convert date format-month Learning Hub datatable , excel , studio	29	5487	October 6, 2020
Can some help me to format this date Studio	6	685	May 15, 2022
How to convert excel column (string) to date format Studio	7	3662	June 8, 2022

Most Active Users - Yesterday
Anil_G
jast1631
donghai
gulsheen_kaur1
More details...

Change Format DateTime

Related topics