SQL - Date Problem

[yakdogs]

I am rather new to SQL and I am having a problem with a date calculation.

This is the formula that I am using:
GETDATE () - Received_Date as AGE
What I am looking for is the number of days between the two.

I know that GETDATE uses the system date, and the system date is correct but in looking at the result it gives a date of 1/5/1900.

I can not figure out what I am doing, can someone help me.

 

[tlbroadbent]

Use the DateDiff Function.

Select Datediff(d, Received_Date, getdate()) as Age
From TableName Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[yakdogs]

Thank you I will give it a try.

 

[yakdogs]

Terry;

I tried your suggestion and it worked, thanks alot.