If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
11 months for expiry
Thank you for your continuos support
I'm trying to make a data base for the employees example the insurance card is dated today and will expire after 11 months. What is the formula that will add 11 months date Insurance expiry date :?? Thank you in advance |
#2
|
|||
|
|||
11 months for expiry
On Sat, 24 Oct 2009 12:56:08 -0700 (PDT), Tia wrote:
Thank you for your continuos support I'm trying to make a data base for the employees example the insurance card is dated today and will expire after 11 months. What is the formula that will add 11 months date Insurance expiry date :?? Thank you in advance Look up the DateAdd function in VBA help. =DateAdd("m",11,[StartDate]) The above value ought not be saved in any table. As long as you have stored the [StartDate] anytime you need the expiry data, re-calculate it as above. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|