Dates filter not working in VBA

[chriscorpion786]

Hello ALL,

I have a macro that filters dates by month and year based on cell values. I have dates that range from the year 2020 till year 2030.
Now the strange part is that all years filter properly except for any dates that lie within the year 2030
I have the below code and could'nt find a solution as to why 2030 dates are not filtering.

>>> use code - tags <<<

Dim startdt As Range
Dim enddt As Range

Set startdt = ThisWorkbook.Sheets("Controls").Range("J2")' e.g format is 01-05-2030
Set enddt = ThisWorkbook.Sheets("Controls").Range("L2")e.g format is 31-05-2030

ThisWorkbook.Sheets("Tasks").Range("A1").AutoFilter Field:=1, Criteria1:=">=" & startdt, Operator:=xlAnd, Criteria2:="<" & enddt

 

[vletm]

chriscorpion786
Those dates would be clng(startdt) and clng(enddt) then those could work better.
( no matter what is Your e.g format )

 

[PCI]

See

ThisWorkbook.Sheets("Tasks").Range("A1").AutoFilter Field:=1, Criteria1:=">=" & startdt * 1, Operator:=xlAnd, Criteria2:="<" & enddt * 1

 

[chriscorpion786]

chriscorpion786
Those dates would be clng(startdt) and clng(enddt) then those could work better.
( no matter what is Your e.g format )

Thank you, your recommendation works..

 

[chriscorpion786]

See

ThisWorkbook.Sheets("Tasks").Range("A1").AutoFilter Field:=1, Criteria1:=">=" & startdt * 1, Operator:=xlAnd, Criteria2:="<" & enddt * 1

Thank you, both recommendations work...