Future Date Calculation Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top