PivotField Date Filter working

[amphinomos]

The first loop works fine but the second date filter won't update. Any ideas would be great :

Please Login or Register  to view this content.

Thanks !

[Izandol]

You may use

Please Login or Register  to view this content.

[amphinomos]

That doesn't work either. I muse have something elsewhere in my code that's not working. Do you think clearing the cache would change anything ?

[Izandol]

Is your field really a date type? Can you manually use the date filters on it?

[amphinomos]

Yes I can manually use the date filters on it. If I use the Macro Recorder, I get the following code :

Please Login or Register  to view this content.

[Izandol]

May you provide a workbook? The solution I suggested does work with Excel 2010 when I test it.

[amphinomos]

I'd like to but can't. Thanks again for your help Izandol !