Query not filtering for dates

[alansidman]

The following query should filter for dates between 1/1/23 and 12/31/23 but lists all values as shown in the anonymized spreadsheet which was exported. The query was built in the UI.

SELECT tblTransactions.Payee, Sum(tblTransactions.Deposits) AS SumOfDeposits, tblTransactions.TypeTrans, tblTransactions.TranDate
FROM tblTransactions
GROUP BY tblTransactions.Payee, tblTransactions.TypeTrans, tblTransactions.TranDate
HAVING (((Sum(tblTransactions.Deposits))>0) AND ((tblTransactions.TypeTrans) Like "Div*") AND 
     ((tblTransactions.TranDate) Between #1/1/2023# And #12/31/2023#)) OR (((tblTransactions.TypeTrans) Like "Int*"));

[CJ_London]

It is also filtering for trantype like int*

[alansidman]

@CJLondon
Thanks'. I needed to add the Between on the line for the Like Int* and now it works. How simple things sometimes elude us.