Create Total Years column in a Query

[BADebbie]

I have a column with a Hire Date, and I want to create a Total Years column. I have tried the following expression, but it didn't work.
=(TODAY()-HireDate)/365.25

[ranman256]

you do date math with DATEADD, or DATEDIFF

=DATEDIFF("d",HireDate,Date())/365.25
or
=DATEDIFF("yyyy",HireDate,Date())

[BADebbie]

I got my answer. it is this expression.

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

[pbaldy]

For the record, your method would work, but there is no TODAY() function. You want Date():

?(Date()-#1/1/2000#)/365.25
16.8569472963723