DateAdd Function Example

The following example shows how you can create a calculated control by using the DateAdd function to display the date by which a particular order must be shipped — in this case, thirty days after the OrderDate. Suppose you have a form based on an Orders table, with a field called OrderDate. You can create another text box on the form to display the shipping date by setting the ControlSource property of this text box as in the following example.

= DateAdd("d", 30, [OrderDate])