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:

Sub All_Filt()

   With Sheets("Finance_Raw").Range("A1").CurrentRegion
   
        .AutoFilter
        If Sheets("Indi_Report").Range("H4") <> "" Then
            .AutoFilter Field:=1, Criteria1:=Sheets("Indi_Report").Range("H4")
        End If
        If Sheets("Indi_Report").Range("H5") <> "" Then
            .AutoFilter Field:=2, Criteria1:="<=" & Sheets("Indi_Report").Range("H5"), _
           Operator:=xlAnd, Criteria2:=">=" & Sheets("Indi_Report").Range("H6")
        End If    
    End With
End Sub

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.