FIlter datatable by time

[Kevin_Maurice]

hi, i have an excel column contains datetime (“yyMMddHHmm”)in string, what i am trying to is filter my datatable by time(“HHmm”), for an example remove all data higher than 4:30 PM which is (yyMMdd1630). can someone help me out?

[fernando_zuluaga]

Hey

can you try with the following code?

dtResult.AsEnumerable().Where(Function(row) DateTime.ParseExact(row("DATE_TIME").ToString(), "yyMMddHHmm", CultureInfo.InvariantCulture).TimeOfDay <= New TimeSpan(16, 30, 0)).CopyToDataTable()

Regards

[Kevin_Maurice]

i have this error sir

[fernando_zuluaga]

Hey

Please check
Main.xaml (12.3 KB)

[Kevin_Maurice]

solved sir, thanks for your help

[Kevin_Maurice]

one more thing sir, can you let me know please how to select data from 16:30 till 21:00?

[fernando_zuluaga]

Hey

check this

dtResult.AsEnumerable().Where(Function(row) DateTime.ParseExact(row("DATE_TIME").ToString(), "yyMMddHHmm", CultureInfo.InvariantCulture).TimeOfDay >= New TimeSpan(16, 30, 0) And DateTime.ParseExact(row("DATE_TIME").ToString(), "yyMMddHHmm", CultureInfo.InvariantCulture).TimeOfDay <= New TimeSpan(21, 0, 0)).CopyToDataTable()

Regards