I have multiple selection criteria but it is ignoring the Date criteria and I don't know why?

[Mark at Thelen]

{TICKETMASTER.TICKET_DATE}= DateTime (2020, 11, 09, 00, 00, 00) and
({TICKETPRODUCTS.SHIP_LOC} = "031" and {TICKETPRODUCTS.CATEGORY_CODE} = "201" and {TICKETPRODUCTS.UNIT_PRICE} <= 5.00) OR
({TICKETPRODUCTS.SHIP_LOC} = "031" and {TICKETPRODUCTS.CATEGORY_CODE} = "203" and {TICKETPRODUCTS.UNIT_PRICE} <= 6.00)

 

[lbass]

TICKETMASTER.TICKET_DATE}= DateTime (2020, 11, 09, 00, 00, 00) and
(
({TICKETPRODUCTS.SHIP_LOC} = "031" and {TICKETPRODUCTS.CATEGORY_CODE} = "201" and {TICKETPRODUCTS.UNIT_PRICE} <= 5.00) OR
({TICKETPRODUCTS.SHIP_LOC} = "031" and {TICKETPRODUCTS.CATEGORY_CODE} = "203" and {TICKETPRODUCTS.UNIT_PRICE} <= 6.00)
)

You need the extra parens to clarify what the "or" applies to.

-LB