Linq query show output 0

[fairymemay (noona)]

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 (17.0 KB)

Please guide me about it.

[prasath_S]

Hi @fairymemay

conver to date using cdate or date.parse and try again…

Thanks

[fairymemay (noona)]

@prasath_S convert StrFilterDate1 right ?

[prasath_S]

both r(“Due date”).ToString and strFilterDate1

[fairymemay (noona)]

@prasath_S SAME, SHOW 0

DateFilter.xaml (17.0 KB)
input.xlsx (20.3 KB)

Please guide me for how to solve it.

[prasath17 (Guru)]

@fairymemay - please refer this post

How to use macro filter excel?

@fairymemay - Here you go DateFilter_Noona.zip (107.9 KB) Currently I have the input date of 22/05/2021 so you see 4 rows filetered, and if you change the date to 20 you will see no rows. Please do delete the Output sheet try both the dates [image] Once you understood what is happening, Repeat the process for CaseCH sheet by yourself.

[prasath17 (Guru)]

@fairymemay - The reason why it is not working is, your cell format is “Date” type.

As you know, Initially i have provided the code with ‘Date’ format later you changed it to ‘General’ type…and then I gave another code.

But this input shows the cell type as Date again, that’s why it is not working. please use “preserve format” while reading and try to adjust the code.

[fairymemay (noona)]

@prasath17 Now , I change code to ‘Date’ format as below.

But If I run I show error.

[NIVED_NAMBIAR (NIVED N)]

Hi @fairymemay
check whether this is working fine or not
IntDrRowCount = (From r In DtCaseCA.AsEnumerable
Where CDate(r(“Due date”)).ToString(“dd/MM/yyyy”) < StrFilterDate1
Select r).Count