Ok, now I feel plain silly. The advanced filter is working fine - it is just filtering out all my records and bringing up data underneath the filter criteria which does not have any data in the last two columns.
So, basically my filter formula for identifying the last 12 entries is not working so I would appreciate any help.