Future Date

  • Thread starter Thread starter aubrey
  • Start date Start date
A

aubrey

I have no idea if what i'm asking is possible, so any help would be
appreciated.

I have two date fields. I want the second field to be populated with a
future date base on the date from the first field. The future date must be
12/31 three years in the future. In other words, field one is 07/29/2008,
field two should populated 12/31/2011.

Again any help would be great.

Aubrey
 
aubrey said:
I have no idea if what i'm asking is possible, so any help would be
appreciated.

I have two date fields. I want the second field to be populated with a
future date base on the date from the first field. The future date must be
12/31 three years in the future. In other words, field one is 07/29/2008,
field two should populated 12/31/2011.
Click to expand...


Use the DateSerial function:

DateSerial(Year(field1)+3,12,31)
 
Back
Top