I have data in a table with the following format.
8/27/2007 12:00:00 AM
My job is to figure out how many days it has been since that day to the current day. Any ideas? usually I would just do a getdate()- whatever. But that is not working as the date is in timestamp form. And I need it in # of days.