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

Help Studio
1

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?

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)
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)1505×488 35.2 KB

date_limit.xlsx (8.2 KB)

2

Hi @chenyanshan_gz

Try this

DateTime.ParseExact(dt.rows(0)(0).ToString,"yyyy-M-dd",System.Globalization.CultureInfo.InvariantCulture)

Regards,

3

Hi,

Thank you for your response, but it still throws an error.

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)
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)1516×375 25.4 KB

Regards,

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),""))

image
image801×487 19.8 KB

Sample
Sample20240821-2.zip (8.5 KB)

Regards,

1 Like
5

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 you sincerely.

Regards,

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.