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
Quick Guidance Please Academic Alliance excel , academic_alliance , question , linq-query	12	1617	April 11, 2022
Filtering the date Activities database , activities , question	10	1431	August 10, 2021
Need LINQ query to filter Excel Activities datatable , excel , activities , studio , question	13	652	June 10, 2023
Linq query in excel date Studio excel , studio , question , activities_panel	10	464	January 11, 2024
Need help to edit code LINQ? Activities excel , activities , question	20	1562	March 6, 2022