Oct 1 2009, 07:45 AM
Here's what I've got.
In the Query field:
Oneed to calculate an age from the DOB (date of Birth) to a specified date (3/1/2010).
I've used DateDiff("yyyy",[DOB],DATE())+(Format([DOB],"mmdd")>Format(DATE(),"mmdd")) in the query and it gave me thier current age. But I need it from the future date of Mar. 01 2010 (3/1/2010). When I replaced the DATE() with 3/1/2010 it gave me a large negative number. Please help.
Oct 1 2009, 08:04 AM
Did you put # around the set future date?
Oct 1 2009, 08:33 AM
Yes with the same results---negative number
Oct 1 2009, 09:02 AM
This works for me
The only way I could get a negative number was to leave off the # delimiters.
You might check the date in DOB if it still does not work.
Oct 1 2009, 09:05 AM
Would this work for you:Age() Function (Allen Browne)
Oct 1 2009, 09:13 AM
Thanks, Truittb. I copy paste it into the field and it worked. I compared the two and couldn't find a difference but it work so thanks.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here