Hi, I have a date column in a data table, which I’m trying to sort by oldest to newest. However, Sort data table activity doesn’t work. Please advise. Thank you

Hi @hp321 , (From r In DT Order By DateTime.ParseExact(r.Item(“YourColumnName”).ToString, “MM/dd/yyyy hh:mm:ss tt”, System.Globalization.CultureInfo.InvariantCulture) Descending Select r).CopyToDataTable Use above code and check the double quotes in (“YourColumnName”) and “MM/dd/yyyy hh:mm:ss tt…

Sort Data Table not working

Help Activities

rashmisingh2695 (Rashmi) October 8, 2024, 9:02am 3

Hi @hp321

You can also try to sort using linq
dtInput.AsEnumerable().OrderBy(Function(row) Cdate(row(“DateColumn”))).CopyToDataTable()

Regards

Topic		Replies	Views
Sort data table activity not working Activities excel , activities , studio , question	2	1783	November 15, 2021
Sort by date time not working Help	27	3611	October 26, 2019
Sort Excel By Latest Date Academy Feedback datatable , excel , activities	21	4444	August 1, 2020
Sort DataTable Activity Not Working as Expected Help datatable , activities , question	4	5497	November 15, 2019
Sort by use linq Activities excel , activities , question	4	162	May 18, 2024

Sort Data Table not working

Related topics