Date COlumn AutoFiltering Issue!

[Admin]

Hi

Use DATEVALUE

DateValue(sReportingFromDate)

[labkhand]

Thanks for your response, but I get "Type Mismatch" error when I use datevalue function since the following line in my FIlterData sub expects Variant values. Additionally, I use this sub in other places to filter data columns based on passed Variant/Array values and thus cannot change the sub declaration to anything else.

Rng.AutoFilter Field:=iField, Criteria1:=vCriteria1, Operator:=sOperator, Criteria2:=vCriteria2

[labkhand]

I was able to resolve this issue using the solution you provided. Thanks for all your help.