DOB Calc

[svobfamily]

I have a table with a DOB and need to have a column to reflect that persons age as of Jan 1 of current year. From there I need another column to categorize that age into a level of jr, intermediate or senior for that participant. So participant Joe's DOB is 1/10/2006 and so as of Jan 1 2017 they were 10 so are in the jr division. Any help appreciated!!

[Homegrownandy]

you shouldnt store this data in a column. The accuracy of the data is only correct for one year. Then after that year your database is full of incorrect data. Instead.... have this calculated on the form level. So its correct data at the time of the query running on the form.

the query for the form should calculate the age. then you may have another query based on this query that will split the rusults how you want them based on age.

[svobfamily]

ok, i think i figured it out myself ~ my table will be imported each year with new participants,,,,,name, dob and gender. I will pull that into a query with one column of current year c_yr to pull Jan 1 of the current year

c_yr: DateSerial(Year(Date()),1,1)

Then another column to calc the age of the participant (c_age) based on c_yr
c_age: DateDiff("yyyy",[DOB],[c_yr])+Int(Format([c_yr],"mmdd")<Format([DOB],"mmdd"))

I was hoping to do this in one column ~ but 2 works too.