date reformatting minus to getdate
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER