Hi,everyone I read the follow excel in the Studio Pro (Version: 2020.4.3), and save it into the datatable, but I can’t convert the data into DataTime type? <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/f/0/e/f0eea1b290c61f5b7412b7ac1f6d5a1f63d331ee.png" data-download-href="/uploads/short-url/ynnRfiE7ArqWUanaqH15oqsLKrA.png?dl=1" title="The image shows an error message "String was not recognized as a valid DateTime" in the output panel of a UIPath automation workflow, indicating an assignment activity that attempts to convert a string to a DateTime format. (Captioned by AI)" rel="noopener nofollow ugc">[The image shows an error message "String was not recognized as a valid DateTime" in the output panel of a UIPath automation workflow, indica…

Hi, It seems same matter with the following topic. [image] How do I extract the dates from this txt file and convert them to data.time format? Studio Hi, everyone I tried using the “matches” activity but failed. <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/8/4/3/84395103ad3a6c77620503c49e7e2fbdeabdb20c.png" data-download-href="/uploads/short-url/iRHPdlGiUQ73CePuzBxKV5OEvBq.png?dl=1" title="The image shows a Regex editor with a regular expression for matching date and time, specifically in the format "YYYY年M月D日 HH:mm:ss", with the "IgnoreCase" option checked. (Captioned by AI)" rel="noopener nofollow ugc">[The image shows a Regex editor with a regular expressio…

Hi @chenyanshan_gz Try this DateTime.ParseExact(dt.rows(0)(0).ToString,"yyyy-M-dd",System.Globalization.CultureInfo.InvariantCulture) Regards,

Hi, Thank you for your response, but it still throws an error. <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/a/0/2/a027059d981124fe78f28fdfc8e76baad55df516.png" data-download-href="/uploads/short-url/mQLZXDcdDKPsGbm5QaQKwYeJl7o.png?dl=1" title="The screenshot shows an output panel with an error message "String was not recognized as a valid DateTime" highlighted, next to a workflow assign activity attempting to parse a DateTime. (Captioned by AI)" rel="noopener nofollow ugc">[The screenshot shows an output panel with an error message "String was not recognized as a valid DateTime" highlighted, next to a workflow assign activity attempting to parse a DateTime. (Captioned by AI)] Regards,

Hi, @Yoichi Thanks for the answer. This table is indeed an extract derived from the text within the referenced topic. It looks like it was a success in getting date data, but it’s not. Extra characters have also been extracted. In the referenced topic, the same problem has been solved by you, thank…

How can I convert the data in this excel into DataTime type?

Help Studio

Yoichi (Yoichi) August 20, 2024, 11:56pm 4

Hi,

It seems same matter with the following topic.

There are many extra characters (0x200e) in your date string.

Can you try to remove them then convert to datetime as the following?

CDate(dt.Rows(0)(0).ToString.Replace(Chrw(&H200e),""))

Sample
Sample20240821-2.zip (8.5 KB)

Regards,

1 Like

Topic		Replies	Views
Assign: String was not recognized as a valid DateTime error Studio studio , question , activities_panel	7	1640	May 23, 2021
Convert to Date Time From String Something Else string , feedback , help , datetime , convert , string-and-date	19	12989	September 24, 2022
Date showing in excel and in the data table are different and needs conversion Activities datatable , uiautomation , activities , error	5	1772	March 24, 2021
How to convert a string to date Studio datatable , excel , orchestrator , studio , question , activities_panel	14	1613	December 15, 2022
Convert String taken from DataTable to DateTime Variable Activities excel , activities , question , system	7	332	January 15, 2024

How can I convert the data in this excel into DataTime type?

Related topics