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