How do I express a datediff in years & months? for example: 2 yrs 3 months

[Barb Crosby]

I am using a query:

LengthofEmploym ent2: IIf(IsNull([TerminationDate]),DateDiff("m",[HireDate],Now())/12,DateDiff("m" ,[HireDate],[TerminationDate])/12)

[Barb Crosby]

LengthofEmploym ent: IIf(IsNull([TerminationDate]),DateDiff("m",[HireDate],Now())/12,DateDiff("m" ,[HireDate],[TerminationDate])/12)

[Rabbit]

Integer division by 12 will give you years while mod 12 will give you months.

[Barb Crosby]

I'm sorry, but I'm not sure what you mean? integer division and mod division. Could you give me an example on how I would write the query?

The result of my query as I have it written gives me .67 years as opposed to 7 months. Is there a way to do this?

[Rabbit]

Int(47 / 12) = 3
47 Mod 12 = 11
3 Years 11 Months.

Int(7 / 12) = 0
7 Mod 12 = 7
0 Years 7 Months.

[Barb Crosby]

Thank you. I will try that :)