Hello everyone. I have a column in excel that I transform into a Data Table. [image] My dates are in formats : dd/MM/yyyy Others (in green) are in MM/dd/yyyy format I would like to convert these dates (in green) to dd/MM/yyyy format. Here is my flow: [image] Here is the error I get [image] C…

@DimitriLYR Then i would suggest use as below use a try catch around the asign activity where you are converting the date… In the catch block use another assign but now use DateTime.ParseExact(datestring,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy") cheer…

Hi, Data in green cell seems datetime type in excel. If so, the following ForEachExcelRow might help you. [image] Condition CurrentRow("date_article").RawValueType =Type.GetType("System.DateTime") Then CurrentRow("date_article") = CDate(CurrentRow("date_article").ToString).ToString("dd/MM/yyy…

Hello, thank you for your answer. I tried this however I can’t make my condition, I have this error: [image] Compiler errors encountered while processing expression CurrentRow(“date_article”).RawValueType =Type.GetType(“System.DateTime”).(2) error BC30574 Option Strict On reject all late bindings …

Hello @DimitriLYR try below. I have modified the @Yoichi code a little bit CurrentRow("date_article").GetType = Type.GetType("System.DateTime")

@DimitriLYR The code given above works inside a use excel scope…i guess you are trying to do it inside a for each row in datatable…please check Cheers

Not valid DateTime

Help Activities

ppr (Peter Preuss) March 20, 2023, 1:58pm 2

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Topic		Replies	Views
Can't get the correct datetime format Activities excel , activities , other	10	1072	September 1, 2023
Convert date format-month Learning Hub datatable , excel , studio	28	5908	October 6, 2020
Read Date from Excel into DateTime Studio excel , variable , question	10	5785	August 6, 2020
Date showing in excel and in the data table are different and needs conversion Activities datatable , uiautomation , activities , error	4	1811	March 24, 2021
How to convert a string to date Studio datatable , excel , orchestrator , studio , question , activities-panel	13	1743	December 12, 2022

Not valid DateTime

Related topics