Sort a datatable

[pandeypriyanka1312 (Priyanka)]

I need to sort a datatable based on a column whose value is in format mm/dd/yyyy hh:mi AM/Pm. Please help me with creating linq query for this

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @pandeypriyanka1312

Please see if below post helps

Datatable sorting with respect to particular column value

Hi Team, I have a datatable with various columns. I want to sort the rows depending on the column “InvoiceNo.”. Like if the invoice numbers are 001 and 002 then the row that has 001 as invoice number will be the 1st row and then 002 invoice number row as the 2nd row. Please help.

Datatable sorting

@USUSER1 You Can use Filter Datatable Activity and In the Filter wizard Keep Columns Section, Mention the Column Names in the Order you want it. The resultant Datatable will be in that particular Order

Sort datatable data based on one column

GroupBy: Display the name of the item of each Brand. Let: dtBrand as DataTable output from read range activity item as “Brand” as the key and row as the data row value from each brand. First For Each: Using For each activity with Argument Type IGrouping: key of string and element of data row. Set the values property with: dtBrand.AsEnumerable().GroupBy(Function (li) li.Field(Of String)("Brand")) [image] Then log the Brand Name using item.key [image] Second For Each: Using Log Me…

Also, you can consider using sort datatable activity for same.

Activities - Sort Data Table

Hope this helps.

Regards
Sonali

[Anil_G (Anil Gorthi)]

@pandeypriyanka1312

Please try this

dt.AsEnumerable.OrderBy(function(x) Cdate(x("Datecolumnname").ToString)).CopyToDatatable

if above does not work use

dt.AsEnumerable.OrderBy(function(x) DateTime.ParseExact(x("Datecolumnname").ToString,"MM/dd/yyyy hh:mm tt",system.globalization.cultureinfo.invariantculture)).CopyToDatatable

cheers

[bhavesh.choubey]

You can use this linq

(From row In yourDataTable.AsEnumerable() Order By DateTime.ParseExact(row(“YourDateColumn”).ToString.Trim, “MM/dd/yyyy hh:mm tt”, System.Globalization.CultureInfo.InvariantCulture) Select row).CopyToDataTable()

If this is Needful then Mark it as SOLUTION

Happy Automation

[sarvesh.b (Sarvesh)]

Hi @pandeypriyanka1312

Try this Linq query

sortedDT = (From row In yourDataTable.AsEnumerable()
Order By DateTime.ParseExact(row(“YourColumnName”).ToString.Trim,
“MM/dd/yyyy hh:mm tt”,
System.Globalization.CultureInfo.InvariantCulture)
Select row).CopyToDataTable()

Thanks!!

[pandeypriyanka1312 (Priyanka)]

I tried this but it gives me error "string was not recognized as a valif datetime. The dates in table are in this format
11/2/2024 9:50 PM
4/24/2025 10:40 AM

[bhavesh.choubey]

The error happens because your DateTime.ParseExact format string doesn’t exactly match the way your date/time strings are stored.
From your examples 11/2/2024 9:50 PM 4/24/2025 10:40 AM. These dates use single-digit months and days without leading zeros, so "MM/dd/yyyy hh:mm tt" is too strict — MM and dd expect two digits.

You need to use M and d for single or double digits, like this:

(From row In yourDataTable.AsEnumerable()
Order By DateTime.ParseExact(
row(“YourDateColumn”).ToString.Trim,
“M/d/yyyy h:mm tt”,
System.Globalization.CultureInfo.InvariantCulture)
Select row).CopyToDataTable()