Setting a second filter with VBA

[VbaHell]

Hello all

This line of code is part of a larger piece for emailing out a group email with an attached workbook which works fine.

The range is column "C" to Column "Z"

It filters on column "W" (Field 21) and the criteria is "Out"
I need to add an additional filter on this if possible

In column "Z" will be a date

I want to only see dates that are less than or equal to todays date but I am struggling to modify the filter.

                FilterRange.AutoFilter field:=FieldNum, Criteria1:=Cws.Cells(rnum, 1).Value
                FilterRange.AutoFilter field:=21, Criteria1:="*Out*"

Any help on this please would be great

 

[VbaHell]

Can anyone help on this please

I have tried this but it's not working

'Filter the FilterRange on the FieldNum column
                FilterRange.AutoFilter Field:=FieldNum, Criteria1:=Cws.Cells(rnum, 1).Value
                FilterRange.AutoFilter Field:=21, Criteria1:="*Out*", Field:=24, Criteria2:="< Date()"

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1089510-vba-filter-column-dates.html
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

I will close this thread as you have answers on the other.