date function

[Parmb]

Hi,

I'm creating a dbase 2 hold info on certain peep in a job. I want to give the dbase a start date then i want it to automatically work out the end date which is 6 months on that.

I,ve created the table with both fields start date and end date. Where do i code this in the form used 2 enter the data?? any eg code anyone??

ANy help Appreciated

thanks PArm

 

[jebry]

Hi Parm!

If you are entering the information via a form, then in the afterupdate event procedure for the start date you can use the following code:

EndDate = DateAdd("m", 6, StartDate)

hth
Jeff Bridgham
bridgham@purdue.edu