Adding Years to a Date

[Joseph31]

This is a very simple problem... I just do not know how to do it.

How do you add years (in a number format) to a date (Date Format)

Example:

21 (Years) + 2-14-05 = 2-14-26

Help

Joseph

[Lee Smith]

Assuming you have two fields already (i.e. a date field and a number field), substitute your field names for "AnyDate" and "Number_of_Years"

Your Calculation Field would look like this:

c_FutureAnyDate (calc, Date Result) =

Date(Month(AnyDate), Day(AnyDate),Year( AnyDate)+Number of Years)

HTH

Lee

[Joseph31]

I am not sure I understand this equation....

Can you help me alittle more?

[-Queue-]

AnyDate is your date field or hard-coded date. Applying it to your example would look like

Date( 2; 14; 2005 + 21 )

or

Date( Month(Date( 2; 14; 2005 )); Day((Date( 2; 14; 2005)); Year(Date( 2; 14; 2005)) + 21 )

or

Date( Month(AnyDate); Day(AnyDate); Year(AnyDate) + YearsToAdd )

as in Lee's calculation.

[Joseph31]

Cool thanks

That helped me... thank you to both of you.

Joseph