Valid Date

  • Thread starter Thread starter Michael Hanlon
  • Start date Start date
M

Michael Hanlon

i have a form where the date i completed a course is setup such as CPR and i
need to setup on a report the expire date which is 1 year after the
completed date. I need to know how to get the date from the cpr field and
add the 1 year so my report will show valid until dates.


any help would be great thanks in advance
 
Thanks for the info worked great.



Allen Browne said:
Use DateAdd().

The Control Source of your text box will be:
=DateAdd("yyyy", 1, [CourseDate])

You can also do that in a query.
If the idea of calculated fields in a query is new, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Michael Hanlon said:
i have a form where the date i completed a course is setup such as CPR
Click to expand...
and
i
need to setup on a report the expire date which is 1 year after the
completed date. I need to know how to get the date from the cpr field and
add the 1 year so my report will show valid until dates.
Click to expand...
Click to expand...
 
Back
Top