<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Adding Numbers To Date/Time Values Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:193.view Date Posted: Aug 4, 2006 at 2:25 PM ---- --------------------------------------------------------------------------------------- ---> SELECT -- Query for yesterday's date. ( getDate() - 1 ) AS yesterday, -- Query for tomorrow's date. ( getDate() + 1 ) AS tomorrow