add months to months

[IEW]

I would like to add a field (Months) to a date field. Any easy way?

Example:

1/1/05 + 42 months

Answer = 1/7/08 ?

IW

[Raybaudi]

Hi IEW

this may do the needed calculation:

Date ( Month ( YourDate ) + months ; Day ( YourDate ) ; Year ( YourDate ) )

[IEW]

Thanx, Im having one of those days.

IW