Link to home
Create AccountLog in
Avatar of casit
casitFlag for United States of America

asked on

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.  
SOLUTION
Avatar of dportas
dportas

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of casit

ASKER

well all three of you are right so I will split the points.