Arrange date in descending order

[sangasangasanga (sanga)]

Is there a way to arrange the date in order?

I tried the below code it isn’t working for date:
dt.DefaultView.Sort = “[Date] DESC”
dt = dt.DefaultView.ToTable

Arrange column in ascending order

Is it possible to arrange the excel column in descending order? Current outcome: [image] Expected outcome: [image] Any suggestions? Thank you xoxo

Thank you xoxo

[arivu96 (Arivazhagan A)]

Hi @sangasangasanga,

Use below LINQ code to sort the datatable

(From p In dataTable Order By DateTime.ParseExact(p.Item("Date").ToString, "d MMM yyyy", System.Globalization.CultureInfo.InvariantCulture) Descending Select p).CopyToDataTable

Regards,
Arivu

[palindrome (Nitin Safaya)]

@sangasangasanga

dt.DefaultView.Sort = “[Date] DESC”
dt = dt.DefaultView.ToTable

This will only work if your datatable column is of type datetime or date.