sql server - SQL execution script

Question

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

question from:https://stackoverflow.com/questions/65922698/sql-execution-script

Answer 1

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

Order_date should be in ''