hi guys i’m trying to read an excel file and sort it base on the date in a column. i initialized the datatable, it gets error when i set the column type as datetime, maybe i should just set it to string ? how do i achieve what i want to do ?

Hi it should Be like this @RobertoEwaldo DateTime.ParseExact(Yourstringvariable,“dd MMMM yyyy H:mm:ss ”.System.Globalization.CultureInfo.InvariantCulture) And use single H instead of double HH This would work For more reference look at this url :upside_down_face:) [image] Prob…

Convert a column of string to datetime

Help

balu (Bharath Yadav) May 6, 2019, 3:07am 3

Hi @RobertoEwaldo
Follow these linK

Thanks

Topic		Replies	Views
Sort datatable by column with date format "dd-mm-yyyy" Help	11	10715	September 13, 2019
Convert String to Datetime and sort a datatable Activities datatable , uiautomation , date , datetime	8	1114	October 27, 2023
Converting String column in a DataTable to DateTime Studio datatable , uiautomation , activities , error	4	3730	October 6, 2020
Convert and Filter Data Table Studio datatable , studio , question , activities_panel	10	2477	November 9, 2021
Sort a datatable based on column name which gives incorrect input string as error Help	24	2500	March 7, 2019

Most Active Users - Yesterday
sonaliaggarwal47
Anil_G
sharazkm32
V_Roboto_V
Somanath1
Ranveer_S_Thakur
afna
mkankatala
andrzej.kniola
PWilliams
More details...

Convert a column of string to datetime

Related topics