How to sort a data table based on a column which is a date

try this

(From row In filteredSchemaDT Order By DateTime.ParseExact(row.Item("RECEIPTDATE").ToString, "dd/MM/yyyy", 
System.Globalization.CultureInfo.InvariantCulture) Descending Select row).CopyToDataTable

Thanks,
Prankur

6 Likes