Calculated age field rounding up
Posted on 2006-05-18
I am calculating camper's age at camp date using DateDiff in a query. However this formula rounds up giving me the wrong age for campers whose birthdays falls after camp. Here's the formula I have in m y query:
I then tried to use int(agevalue) as follows:
This gives me the same result, perhaps because I'm trying to use int with DateDiff
How can I get the calculated age field not to round up?
Would it be better to put this in a function instead of in the query?