|Figure 1 (above): This shows the DateAdd function used|
as a Calculated Field in a Query. You can see an example of a Calculated Field
in my post on the related DateDiff Function. (NB DateDiff calculates and returns the difference between
two dates, whereas DateAdd calculates and returns a new date based on the value of the number parameter passed).
|Figure 2: This shows the DateAdd function used as a Calculated Control in a form. It can be entered|
into the CONTROL SOURCE property or directly into the text box on the Form Design Grid.
|Figure 3: This shows the DateAdd function used in the fourth line of this VBA code snippet.|
The rstLoan object is a DAO Recordset, and DueDate is the field name in the tblLoans Table.
You can see the rest of the code in last weeks blog post on the DAO Recordset.