wildcard in advance filter VBA

Im trying to filter out vaules by date. currently this works fine, except i am not adding time to the filtered dates in the same cell (example: "7/06/2017 10:32:31 AM")
I would like to still search for the date in the cells but I want the filter to ignore the time. I figured i could do this by adding an asterisk after the date as a wildcard, but have had no luck. Any Ideas?

Please Login or Register  to view this content.

Perhaps insert 2 criteries - so the criteria range should be N10:M11 where...

N11: = ">=Date1"
M11: ="<=Date1+1"

Originally Posted by quekbc

Perhaps insert 2 criteries - so the criteria range should be N10:M11 where...

N11: = ">=Date1"
M11: ="<=Date1+1"

could you elaborate on this a little? i am having trouble trying to figure out how to set this up

Try the attached. I'd type more but I keep getting blocked by the $@#$# Sucuri Firewall