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

[maria.josephina]

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

[PrankurJoshi]

Hi @maria.josephina

See this

Sorting Date

Hi Everyone, I have a date column in my excel sheet and i want to read only those rows which date is starting from 15 till 31st of a month. Please note that the first value in my date column is not a date it has a number of this form written in it and rest of the date format is dd/mm/yyyy

Sort DataTable based on column value

Hi, I have an Excel looking like this: Column1, Column2, Column3 XX, XX, -1040 XX, XX, -104 XX, XX, -1072 XX, XX, -1087 XX, XX, -111 I want to read this and sort the DataTable based on valuesd in “Column3”. This is the result using when using DataView.Sort(ascending): -104 -1040 -1072 -1087 -111 This is of course not the result im looking for. Does anyone have any idea how i can do this sorting?

Thanks,
Prankur

[maria.josephina]

Hi @PrankurJoshi

THankyou
datatable dt = (From row In dt2.Select Order By Convert.ToInt32(row("Column1")) Select row).ToArray.CopyToDatatable()

This worked.
But how to specify the order type (ASC or DESC)

[PrankurJoshi]

@maria.josephina

datatable dt = (From row In dt2.Select Order By Convert.ToInt32(row("Column1")) Select row).ToArray.CopyToDatatable()

Use this for desc

datatable dt = (From row In dt2.Select Order By Convert.ToInt32(row("Column1")) Descending Select row).ToArray.CopyToDatatable()

[maria.josephina]

@PrankurJoshi

Descending

Thankyou somuch.
I have created the below statement for Sorting based on Datetime.

This is not working :
(From row In filteredSchemaDT.Select Order By DateTime.ParseExact(row(“RECEIPTDATE”), “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Descending Select row).ToArray.CopyToDatatable()

[PrankurJoshi]

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

[maria.josephina]

Worked well. Thank you so much for helping out