Automatic field update

  • Thread starter Thread starter Jonathan
  • Start date Start date
J

Jonathan

I need a field to automatically show the difference
between two dates in a form. The value should be displayed
in years and should include decimal places. Could anyone
advise please.
 
Set the Control Source of the text box to:
=([EndingDate] - [StartingDate]) / 365.25
where "endingdate" and "startingdate" represent the names of your existing
date controls.
 
Back
Top