Filtering column for dates

[DJhuffman]

So part of the process I wish to incorporate into my macro includes a step where I would filter column D (which are a series of dates) by two requirement:
1) Show all dates before last month
and
2) Show all dates listed as 00/00/00

I was able to filter for the dates before last month using:

    Dim sdt As Date
    sdt = Month(Date) - 1 & "/1/2019"
    ActiveSheet.UsedRange.AutoFilter 4, "<" & sdt

But I have yet to determine how I might be able to broaden the command to include all dates listed as 00/00/00. Any thoughts?

 

[Marcelo Branco]

Maybe

Dim sdt As Date

sdt = Month(Date) - 1 & "/1/2019"
ActiveSheet.UsedRange.AutoFilter 4, Criteria1:="<" & sdt, Operator:=xlOr, Criteria2:="00/00/00"

M.

 

[DJhuffman]

I think that did it. Thank you! I had attempted something similar in other attempts, but I see that my mistake was using the wrong operator.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.