Future Date

[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

 

[Marshall Barton]

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.

Use the DateSerial function:

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

 

[aubrey]

Works great.

Thanks Marsh

Use the DateSerial function:

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