Hi Everyone, I want to convert dates in general format to Date Time format in Excel. How can I do this? I read Excel with Read Range and converted it to Datatable. Later, when I convert to String and ConvertToDateTime, I get the following error. [image] [image]

Try this DateTime.ParseExact(date_time,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy")

Convert to Date Time From String

Sudharsan_Ka (Sudharsan Ka) September 21, 2022, 7:52am 17

You need to change the column type to date in excel right?
you can achieve it using a modern activity or BalaReva Activity

Check out this image and skeleton xaml file for modern

Checkout this thread for Balareva activities

Regards
Sudharsan

2 Likes

Datatable add data row(s) to a new column

Forum Engagement Daily Reports

Topic		Replies	Views
How to convert date from general format to DateTime format Academy Feedback	3	4209	February 1, 2019
How to Convert this string to date type Studio studio , question , activities_panel	3	1184	February 4, 2022
String to Date Converstion RPA Discussions coding	6	1886	February 23, 2022
String to Date time conversion issue Help	5	1038	June 18, 2019
Date time conversion to string and get only date in string format Studio studio , question , activities_panel	5	214	October 23, 2023