how to show future dates

[lancemeroniuk]

Hi all... need some advice..

I have a form and with the dates that employees have taken a course... now I want to have another box show when this employees course is up for renewal... say 3 years from the date taken...

Make sence..... I hope so...
Thanks in advance

Lance

 

[danvlas]

AnotherBox controlsource:

=DateAdd("yyyy", NumberOfIntervals, [CourseDateBox])

"yyyy" to add years
"q" quarters
"m" months
"ww" weeks
"d" days
"h" hours
"n" minutes
"s" seconds

Good luck

Daniel Vlas
Systems Consultant
danvlas@yahoo.com