I've used a formula to calculate age in a query. The only formula that works is one that uses the "now" feature. I want to calculate the age of a person based on a defined date. For example: I need to know how old a person is on or before May 1, 2012. This is a youth athletic association so it has to be precise. We usually print registration information in January. This formula works, but I'm not sure where to put "5/1/2012". Thanks.
CalAge: DateDiff("yyyy",[DOB],Date())+(Date()<DateSerial(Year(Date()),Month([DOB]),Day([DOB])))