Though the issue is quite old, but I am facing the same issue (Win 7 - MS Access 2010) (Sample db attached)
The builtin date filter does work properly (probably due to the format of date in table is different from that of in the dialog box)
I haven't found any way yet to cope with this...