Sort a datatable based on column name which gives incorrect input string as error

Help
1

Hi All,

Have to sort a data table based on date time column which is in the format yyyy-mm-dd hh:mm:ss

Also time appears as a next line in the same column. Any solution please

I have used the below code but its not working. Without time

(From row In dtResult Order By DateTime.ParseExact(row.Item(“Column control menuUpdatedSort”).ToString, “yyyy-mm-dd hh:mm:ss”,
System.Globalization.CultureInfo.InvariantCulture) Descending Select row).CopyToDataTable

Thanks
Teenu

2

I tried out this code, but not working

(From row In dtResult Order By DateTime.ParseExact(row.Item(“Column control menuUpdatedSort”).ToString, (“yyyy-MM-dd HH:mm:ss”),
System.Globalization.CultureInfo.InvariantCulture) Descending Select row).CopyToDataTable

3

hi @ teenu
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

4

I tried the same code
(From row In dtResult Order By DateTime.ParseExact(row.Item(“Column control menuUpdatedSort”).ToString, “yyyy-MM-dd HH:mm:ss”,
System.Globalization.CultureInfo.InvariantCulture) Descending Select row).CopyToDataTable

It gives me error “String was not recognized as a valid DateTime”

5

@Teenu

please show the Date time which is written in the excel any

There might be issue with datetime format

6

Is your column date similar to “yyyy-MM-dd HH:mm:ss” this format. And make sure in-between date and time is having only one space

7

I get the value in the column field of the data table as 2019-03-04 09:26:32

8

“yyyy-MM-dd hh:mm:ss” try this.

9

will try and let you know

10

No, this format also not working

When printing that column name value- I get as

2019-03-04 09:27:43
03-04 09:27
8mo

11

From row In datatable.Select Order By Convert.ToInt32(row(“Column1”)) Descending Select row).ToArray.CopyToDatatable()

12

(From row In dtResult.Select Order By Convert.ToInt32(row(“Column control menuUpdatedSort”)) Descending Select row).ToArray.CopyToDatatable()

I used the above code and it says “Input String in not correct format”

13

How to extract only DateTime value from the below value:

“2019-03-04 09:26:32\r\n\r\n03-04 09:26\r\n\r\n8mo”

14

How to extract only DateTime value from the below value:

“2019-03-04 09:26:32\r\n\r\n03-04 09:26\r\n\r\n8mo”

15

I think you have created a separate post for this issue. You can find answer there

16

System.Text.RegularExpressions.Regex.Match(“2019-03-04 09:26:32\r\n\r\n03-04 09:26\r\n\r\n8mo”, “[0-9]{4}-[0-9]{2}-[0-9]{2}\s[0-9]{2}:[0-9]{2}:[0-9]{2}”).Value

17

@Teenu try this

(From p In dataTable Order By DateTime.ParseExact(p.Item(“Date”).ToString.SubString(0,10), “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Ascending Select p).CopyToDataTable… It worked for me.

18

Thank you Madhavi, I will try this and let you know
Thanks a lot for your time

19

“date” column is a String type here

20

Teja

Still it gives me error “String was not recognized as a valid DateTime”

(From row In dtResult Order By DateTime.ParseExact(row.Item(“Column control menuUpdatedSort”).ToString.SubString(0,10), “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Ascending Select row).CopyToDataTable

where “Column control menuUpdatedSort” is the column name where the date has to be extracted which is of string data type