Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date function

Status
Not open for further replies.

Parmb

Technical User
Dec 17, 2001
89
GB
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top