I'm writing a stored procedure that will gather a few attributes and put those on a report of events that happened yesterday. I'm having trouble with the date. How do I put this in a WHERE clause to select the events that occured yesterday.
Here's what I have so far:
SELECT d.ToName, d.CreationTime, df.NumPages
FROM documents d INNER JOIN docfiles df ON
d.docfileDBA = df handle
WHERE d.CreationTime >= (yesterday's date)
Thanks
Here's what I have so far:
SELECT d.ToName, d.CreationTime, df.NumPages
FROM documents d INNER JOIN docfiles df ON
d.docfileDBA = df handle
WHERE d.CreationTime >= (yesterday's date)
Thanks
Comment