I have a table that lists the year a piano is made. The specific date is unknown only the year. I want to find the age of the piano. in the past I have used "DateDiff("yyyy",[YearBuilt],Date())" as a way t find date diff but this time it recognizes all the dates as the same. is there a way to calculate the age using the year only?

Using the DateSerial function, change your YearBuilt into a real date. Then use the result of that function in your DateDiff function.

If you are happy with your expression, then you just have to assume a month and day ...

IIf([YearBuilt] Is Null, Null, DateDiff("yyyy",CDate([YearBuilt] & "-01-01"),Date()))

But one thing that is important to know is that DateDiff() will only consider the interval you are wanting the result in. For example:

DateDiff("yyyy",#2012-12-31#,#2013-01-01#) = 1

So, even though the two dates are only different by a day, the result is 1 year because that is the unit being evaluated is the year.

Thanks I will try it All the pianos in question are OLD

Your welcome ... Ya know, since you just have the Year, you really don't need the DateDiff() function --- or DateSerial()! ... you can just get the year portion of the current date....

Year(Date()) - [YearBuilt]

This fits the bill perfectly! Thanks (IMG:style_emoticons/default/woohoo.gif)