Valid Date

[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

 

[Allen Browne]

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

 

[Michael Hanlon]

Thanks for the info worked great.

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.

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.