I use linq query as below. but output show 0 IntDrRowCount = (From r In DtCaseCA.AsEnumerable Where r(“Due date”).ToString < StrFilterDate1 Select r).Count variable StrFilterDate1 as string 05/06/2021 Column Due date in file excel format as date. data filter2.xlsx (36.7 KB) DateFilter.xaml …

Linq query show output 0

prasath17 (Guru) June 8, 2021, 11:46am 6

@fairymemay - please refer this post

Topic		Replies	Views
I am not able to filter on date in a data table Studio studio , question , activities_panel	35	2907	August 23, 2021
Need to filter Excel Data based on Date Activities datatable , excel , activities , studio , question	39	1960	June 8, 2023
Filtering the date Activities database , activities , question	10	1461	August 10, 2021
Linq to filter "Date" column in datatable Studio studio , question , activities_panel	8	3502	October 28, 2022
Linq query(2) Help datatable , excel , uiautomation , studio	16	3709	September 23, 2019