I am working on a project which requires an issue date and a review date.
Currently the user would have to input both dates manually, but since they could easily make a mistake, and as the review date is always 2 years after the issue date is there a formula I can use to allow access to do this automatically.

Here is an example how the date is set up on the form:


Issue Date: 28/08/2008
Review Date: 28/08/2010

your help is much appreciated.

Hi Adam

Thank you for your question

I am assuming that you are entering data through a form. If this is the case then you can attatch a dateadd function as the default value of the review date text box.

Bring your form up in design view and select the text box that displays the review date. Then open the properties dialog and go to the data tab

In the Default property type the following


=DateAdd("yyyy",2,[IssueDate])

This is the date add function

yyyy specifies that you are adding years to the date
2 specifies the number of years
[Issue Date] is the field that you are increasing

Hope this helps

Regards

Stephen