Need to Calculate a Future Date from a Beginning Date

  • Thread starter Thread starter Lee
  • Start date Start date
L

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
 
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])
 
Lee said:
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.
Click to expand...

Use an expression with the DateAdd() function.

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