Calculate a date from number of months

[pleashelp]

I am using CR 9.0. I have a field that shows the date an item was purchased (DTPurchased)e.g. 10/25/1991. And a field that tells me the number of months in the loan (Mths)e.g 60.

I need to calculate when the loan will be paid off based on these 2 fields. Any ideas?

Thx

 

[dgillz]

Use a formula:

Dateadd("m",{MonthsField}, {LoanDateField})

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[michbell]

You should be able to create this formula:

dateadd("m", {mths}, {DTPurchased})

 

[pleashelp]

Thanks, That did it!!