Criteria1 won't work with dates?

Hi all, i got a data table with filters.

when i try to get filter criteria for a non-date field with the following code all is ok

Dim lo As ListObject
Set lo = Worksheets("xxx").ListObjects("yyy")
if lo.AutoFilter.Filters(12).on = True then
   txt = lo.AutoFilter.Filters(12).Criteria1
end if

but when i try to get the same info for a date field i am getting Application defined or object defined error on the last line

lo.AutoFilter.Filters(12).on

returns True but .Criteria1 gets this error

any ideas??

Try recording your filtering operation on Date column and see what is returned.

You should see something like below.

    ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=1, Operator:= _
        xlFilterValues, Criteria2:=Array(2, "1/2/2018", 2, "1/6/2018", 2, "1/7/2018", 2, _
        "1/8/2018", 2, "1/9/2018", 2, "1/10/2018", 2, "1/11/2018", 2, "1/12/2018", 2, "1/13/2018" _
        , 2, "1/14/2018", 2, "1/15/2018", 2, "1/16/2018", 2, "1/17/2018", 2, "1/18/2018")

Date filter has special logic applied and uses Criteria2.