SQL execution script

We want to Execute the "close" for the old open PO in our system. We pull the scripts below but shows nothing. see the screenshot and scripts below. Where did it get wrong and what the execution query would be?

select purchase_order.ID, order_date, status
from purchase_order
where STATUS = 'r' and order_date < 2020-01-01






Continue reading...