Future Date Calculation Expression

[Guest]

I am able to calculate a future date using the following expression:
=DateSerial(Year([StartDate1]),Month([StartDate1])+6,Day([StartDate1]))

However when using this expression it changes my control source to it and
data does not get saved to the table. Is it possible to use this expression
and have data saved to the table? Like one of the other users I must have
the information saved.
Any assistance will be greatly appriciated.

-Eric

 

[Allen Browne]

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains when and how to save a calculated field.

(In essence, it's a good idea if you want it to default to 6 months ahead,
but have the freedom to change it to another value.)

 

[Guest]

If you want to add six month to your date field, you might want to cosider
using the dateadd function
=DateAdd("M"",6,[StartDate1])

e.g
dateadd("m",6,"30/8/2004") will return 28/02/2005
DateSerial(Year("30/8/2004" ),Month("30/8/2004" )+6,Day("30/8/2004" ))
will return 2/03/2005