Advanced Filter goes wrong when carried out by Macro

Please see the attached.

When I recorded the marco which applies an advance filter to the data on 'dump data' sheet it gave me 35 results, plus the header in bold which is correct.

When re-running the macro it seems to pull in the whole database from the 'dump data' sheet, not just the 35 records I would expect.

I cant work out why it does this?

Any ideas?

Regards BVG

Hi Badvgood
I believe you have a "Date" issue. Attached are two files DB1.v2.xlsm and BD1 v2.1.xlsm.

In DB1.v2.xlsm you're criteria is defined as Next.service.dateNext.service.date
>=01/12/2011<=07/12/2011
and it consistently returns 715 records

In DB1.v2.1.xlsm I've defined the criteria as
Next.service.dateNext.service.date>=12/01/2011<=12/07/2011
and it consistently returns 35 records.

So, it appears to be an issue of how the procedure is reading the dates. The procedure appears to be reading M/D/Y. Hope this helps.