Date * # of Months to obtain a date in expression

[d9pierce1]

Not sure how to word this but here we go....
I am trying to do the following but have had no success with this and
have not been able to find anything on the web as an example that doesnt involve two dates....


PayOffDate: [LoanDate] * [TermLimit]




[LoanDate] is a date in qry
[TermLimit] is # of Months


PayOffDate should = the LoanDate * # of Months

Thanks
Dave

[Bob Fitz]

Try:

PayOffDate: DateAdd("m", [TermLimit], [LoanDate])

as a calculated field in a query.

[d9pierce1]

thank you so much. I tried a lot of tries but dates just kill me in this.
Have a great day
Thanks again

[Bob Fitz]

thank you so much. I tried a lot of tries but dates just kill me in this.
Have a great day
Thanks again

Always glad to help if I can

BTW Thank you for the kind words you left in the reputation comment. They are much appreciated.