Queries using the end of current year date

In November of each year I need to be able to update the age of each member as of 12/31/XXXX, whatever the current year. How do I write the update queries EofY Age and EofY LOM without having to change the date in the queries each year? Thank you.
lherouxAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
lluddenConnect With a Mentor Commented:
Age at end of current year is:

UPDATE mytable SET Age =  int(DateDiff("m",Birthdate,DateSerial(Year(Now()),12,31))/12)
0
 
Patrick MatthewsCommented:
To get the end of the current year:

Dateserial(year(now()),12,31)
0
 
QlemoDeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
All Courses

From novice to tech pro — start learning today.