Dates

[peterbowles]

Hi all

I have a field on a form that you insert a date (the start date) I have another field which is the completion date. The completion date is 6 years from the start date. I want to be able to insert a start date and then automatically the completion date is entered into the completion date field

Any help would be great thanks

 

[Newman]

DateAdd("y",6,[StartDate])
y for years; m for months; ww(double) for weeks; d for days

 

[peterbowles]

dates (help again)

[Thanks for the reply can't get it too work. I have two field one is dateStart one is CompDate where do I need to put the code I type in the start date in the DateStart Field would I then put that code in to the after update event.

I am affraid I am still to new to all this thanks anyway

 

[Newman]

The after_update of the StartDate field seems good to me, but I'm not sure.
Maybe something like this:
CompDate = DateAdd("y",6,DateStart)
Newman

 

[R. Hicks]

It should be:

DateAdd("yyyy",6,DateStart)

"yyyy" is for adding years.

"y" is for adding Day Of Year.

HTH
RDH