Need to Calculate a Future Date from a Beginning Date

[Lee]

Have a database. Field entitled "Training Date." This
contains an inputted date. I also have a field
entitled "Next Training Date." I want the report to show
a date in the future (let's say a year) from the date in
the "Training Date" field.

How can I do this.

Lee

 

[Sandra Daigle]

Look at the DateAdd function - it allows you to add intervals to a date. For
example, the following adds one year to today's date:

dateadd("yyyy",1,date())

So for your purposes you would say:

dateadd("yyyy",1,[training date])

 

[Rick Brandt]

Have a database. Field entitled "Training Date." This
contains an inputted date. I also have a field
entitled "Next Training Date." I want the report to show
a date in the future (let's say a year) from the date in
the "Training Date" field.

Use an expression with the DateAdd() function.

=DateAdd("yyyy", 1, [Training Date])