11 months for expiry

  • Thread starter Thread starter Tia
  • Start date Start date
T

Tia

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expiry dates query 1
expiry dates reminder 1
expiry dates report 2
monthly expiry 9
Access Microsoft Access Calculated Field - Expiry Date 0
Subtracting months formula 5
Data Entry Form. 3
Problem with "IF" function 8

Back
Top