Are you sure you need the wildcards?

For example (John Smith 2/6/2019)

"Jo*"
"Sm*"
"2/6/*"

doesn't seem logical for a date. How do you intend to use the date search?

Could you use a date range (From - To)?


Then the filter would work like the fragment below

Option Explicit
Sub Macro1()
    Dim D1 As Date, D2 As Date
    
    D1 = #2/1/2019#
    D2 = #2/28/2019#
    
    Range("A1").AutoFilter
    ActiveSheet.Range("$A$1:$A$44").AutoFilter Field:=1, Criteria1:=">=" & Format(D1, "mm/dd/yyyy"), Operator:=xlAnd, Criteria2:="<=" & Format(D2, "mm/dd/yyyy")
End Sub