# Calculate number of years

I have a form with a field that the user enters a year into.  If they enter for example, 1902, in the field, I want the difference between this year (2015) and the year entered to be calculated in a 2nd field.

For some reason right now if I enter 1902 in the 1st field I get 110  ?????
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
What were the two dates you used?  Post your expression also.
Author Commented:
Expression in the number of years field on the form:

=DateDiff("yyyy",[txtYearOfEntryToUS],Date())

I entered 1902 in field txtYearOfEntryToUS and would expect field 2 to return 113.  Instead I get 110.
Commented:
DateDiff() requires two date fields.  You are using an integer and a date.  Why not just do a simple subtraction?

= Year(Date()) - Nz(txtYearOfEntry)

Experts Exchange Solution brought to you by