On a form I have two date fields (formatted as short date). One is Date1, and the other is Date2.
Then there is a third field named Age.
Age needs to be calculated by using Date2 minus Date1.
For example. is Date1 is 1/1/2010 and Date2 is 1/7/2014 then the result in Age should be 4 (a whole number).
What would the code be for the afterupdate event of Date2?