Please see the below script:
As you can see I created a variable called vParam which is equivalent of GETDATE() - 1. Although, pay attention to the date format 'YYYY-MM-DD', this is SQL Server default date format.
The original table had the below data:
After I ran the QV script, I got the below results which gave every record that didn't have today's date:
And here is my stored procedure for this exercise:
hope this helps.