Get Yesterday's Date
Often times, we want to analyze data with the date from yesterday. How do we auto-populate yesterday's date? There are a few formats that we can use!
The syntax below lets us get yesterday's date with timestamp:
To only get yesterday's date at 00:00:00:
If you wish to get the date and ditch the timestamp completely, you can use the SQL formatter!
You can also use the interval syntax for a more elegant code:
select [getdate():date] - interval '1 day'