DateDiff

[TheHarleygirl2005]

I am calculating Longevity in a query using the following formula

YearsOfService: DateDiff("yyyy",[Service Date],Now())+Int(Format(Now(),"mmdd")<Format([Service Date],"mmdd"))

This works perfect to calculate based on today's date. However, I would like to change the formula so it will calculate effective December 31st of the current year rather then Now().

Can anyone help with this?

[June7]

DateSerial(Year(Date()), 12, 31)

[TheHarleygirl2005]

Thank you! That was exactly what I needed.