Calculated Date

[miziri]

Hi,

Plz see attached file


I need function to calculated date when I add first add in form auto calcu second date and third date. like below:
example:
-like first date:
1-6-2010
i must calculated second date in form like
1-6-2011
must calculated and third date the second date add six month result appear:
31-6-2011

I am second attached my database

thx

[alansidman]

Use the DateAdd function.

Here is the explanation

http://www.techonthenet.com/access/f...te/dateadd.php

Alan

[miziri]

Hi,
Friend I will enter first date,other second and third date computer must calculate it
only first date i will enter manually second and third will be add auto like below example:
First date 16-2-2012
second date and third date will appear in form after u enter first date.
I need second date= firstdate date+6 year
thirddate=seconddate+6 month

thx

[alansidman]

I understand your issue and gave you the solution. Did you not read the tutorial? Put the formula in each of the text boxes you wish to have calculate the dates. Is there something that is unclear to you? Did you try the solution? What results did you get that were unsatisfactory?

Alan