VBA Filtering data for "dates" YearToDate and Text in same column

[Tims_23]

Hello all, One tricky Question,

I have used following argument to filter all the dates before Today() and a text "No forecast " in a particular column:

'filter No forecast and Past dates from col. T

--> ActiveSheet.Range("$A$3:$BN$978").AutoFilter Field:=icol, Operator:=xlFilterDynamic, Criteria1:=xlFilterYearToDate, Operator:=xlAnd, Criteria2:="No Forecast"

Still it gives me empty cells. Can't seem to find any other alternative.
while it runs perfectly if used each one.

Thanks in Advance.
Any help will be appreciated.

 

[Tims_23]

'filter No forcast from col. and Past dates


ActiveSheet.Range("$A$3:$BN$978").AutoFilter Field:=20, Operator:=xlFilterDynamic, Criteria1:=xlFilterYearToDate, Operator:=xlAnd, Criteria2:="No Forcast"

 

[Tims_23]

'filter No forcast from col. and Past dates
   

        ActiveSheet.Range("$A$3:$BN$978").AutoFilter Field:=20, Operator:=xlFilterDynamic, Criteria1:=xlFilterYearToDate, Operator:=xlAnd, Criteria2:="No Forcast"

'filter No forcast from col. and Past dates


ActiveSheet.Range("$A$3:$BN$978").AutoFilter Field:=20, Operator:=xlFilterDynamic, Criteria1:=xlFilterYearToDate, Operator:=xlAnd, Criteria2:="No Forcast"