How to get dates list from list object filter

Hi all,

I got an excel table (list object) with at least one of its columns being a Date field. the user manually applies multiple filters/criteria in various columns. i am trying to get the text of all filters/criterias the user entered. So if no date filter is applied the following code works fine.

Please Login or Register  to view this content.

The moment the user applies a filter on a date field i get app defined or object defined error.

This is how fl looks like in watch window when in fact i have applied 3 criterias in both filters the second of wich is a date field:

fl.png

Any ideas??

Hi, I believe this is a "bug" or at least a known-issue where date filters are applied on date fields with "date grouping" enabled

the below links outlines an XML type approach but I won't pretend to have looked at it in any detail

https://stackoverflow.com/questions/...62115#32062115

so, as I say, if you need this (and above approach not viable) you would need to consider disabling the date grouping feature in the first instance (i.e. pre-filtering):

Please Login or Register  to view this content.

at which point you should find you can pick up the filtered dates...

of course with the 2nd option there is a pretty notable downside to that for an end-user pending volume / disparity of dates at source.

Hi, yes this seems to work around the problem.
However, it is strange as without disabling grouping, if i try to do the same thing with programatically setting the filter criteria in plain data (no list object) this looks to work (?):

Please Login or Register  to view this content.

ok got you. anyone knows if this is fixed post office 2016? i will test the alternative you give and see how it works. i got a feeling tho that the first workaround will work better. any way thx!