Does the boundary date itself make the cut?

Q: Does the boundary date itself make the cut?

The <= operator includes the boundary date itself. Shipment 1 (May 1) and shipment 2 (May 10) both satisfy shipped_date <= '2024-05-10'. Shipments 3 and 4 are after May 10 and are excluded. This is the same chronological comparison you would apply to numbers - dates earlier in time are 'less than' dates later in time.

Question

Accepted Answer

The <= operator includes the boundary date itself. Shipment 1 (May 1) and shipment 2 (May 10) both satisfy shipped_date <= '2024-05-10'. Shipments 3 and 4 are after May 10 and are excluded. This is the same chronological comparison you would apply to numbers - dates earlier in time are 'less than' dates later in time.