I am trying to sort (DESC) a datatable by a column, which comes in date format (dd-mm-yyyy); but the sort activity is taking it as a string. Any idea of how I might be able to accomplish this? Many thanks for any input you might be able to provide with.

Hello @mesalcan you can also use linq here use this code in an Assign Activity and assign it to a Datatable Type Variable and write it in a sheet Dt.AsEnumerable().OrderByDescending(Function(r) CDate(r("C2").ToString.Trim)).CopyToDataTable Check this workflow for better understanding Sorting Dat…

Sort datatable by column with date format "dd-mm-yyyy"

Help

chenderson (Cary Henderson) September 9, 2019, 4:35pm 8

Good afternoon mesalcan,

Does the solution in this post resolve your issue?

Topic		Replies	Views
How to sort a data table based on a column which is a date Academy Feedback	7	13519	December 20, 2018
Sort by date time not working Help	27	3574	October 26, 2019
Sort Date by Month Activities database , activities , question	8	2585	March 11, 2022
Convert a column of string to datetime Help	19	9342	May 10, 2019
Sort Date Time in String Format with AM PM Help	6	3495	November 19, 2020

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

Sort datatable by column with date format "dd-mm-yyyy"

Related topics