Locked in side a tiny room with a keyboard and many monitors glowing away in the dark...
Unanswered: SQL 2005 Reports last 24 hours of data
I am working in Sql Server Reporting Services 2005 and need to create a report that only pulls the data from the last 24 hours. I have used the GETDATE() in the WHERE clause to no avail, such as:
WHERE column_name BETWEEN GETDATE() AND GETDATE()-1
Also have added GETDATE() to the SELECT statement with the same WHERE clause as above....
So what am I missing....it needs to capture all data with in the 24 hour period from the time the report is run, so...if the report is run at midnight Monday it should pull all data back to midnight Sunday.
Thanks in advance!!
Torchwood "understand, in a sick and twisted sort of way?"