I have a SQL Server 2008 Database. I need to run a query that pulls all records received Yesterday. This will be an automated report and I'm having an issue with the get date function
The DateRECD field is a date time in the format 01/03/2020 00:00:00. I'm using the GetDate()-1 function to get the data but Getdate()'s Time portion is as of the time the query is run. How do I get GETDATE()-1 to return the date but lose the time or at least set the time to 00:00:00