Simple help with a line of code, please?

[Guest]

I'm using this for a custom field in outlook:

DateDiff("m", [ContractDate] , Date())

to show how long a client has been with us in months. I'd like to change
that to years but I can't get it.

I've tried changing the "m" to "y" with no success

and tried adding /12 to the end of the formula with no success either.

Help?

 

[Sue Mosher [MVP-Outlook]]

"yyyy" not "y". See http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctDateDiff.asp

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers