Help with an IIF statement

[Bri]

Hello

This is probably a newbie question, but here goes...

I want to write an IIF statement in the Control Source property of a
combobox. It is a calculation based on the field [bday], a student's date
of birth. Here's what I want the statement to do:

If TODAY's date is July 1 or later, show the student's age on the following
January 1.
If TODAY's date is before July 1, show the student's age on January 1 of
the current year.

Help much appreciated.
Thanks
Bri

 

[Allen Browne]

Copy the Age() function from this web page into a standard module:
http://allenbrowne.com/func-08.html

You can then use this in the Contorl Source of your text box:
=Age([bday], DateSerial(Year(Date()) + (Month(Date()) < 7),1,1))