Date Filter working In One Computer but Not Another

Hello

I am using Excel 2002 being populated by a query in Access via MS-Query.

I have a date filter that is working in my home computer but not my office computer. The code is:

Please Login or Register  to view this content.

I'm not sure if this is an issue but the other computer's time settings are d/m/y and mine are m/d/y but it's on a network and I can't change anything. The first part of the filter (for department) works fine in both settings which is why I think there might be an issue with the date format.

Any and all assistance greatly appreciated - thanks.