I'm writing an aging report that will accomodate PROX terms and wonder if anyone could help with a formula.
 
For a given invoice date, I'd like a formula to return the date for, say, the 25th of the next month.

Looks good, except it won't wrap to the next year properly.
 
I think I can work with it though.
 
Thank you.

I've been kicking this little gem around:
 
date(Year(dateadd('m',{@ProxMo},datetime({BKARINVT.BKAR_INVT_DATE}))),month(date
add('m',{@ProxMo},datetime({BKARINVT.BKAR_INVT_DATE}))),25)
 
The @ProxMo formula determines whether to advance one month or two, depending on the invoice date:
 
if day({BKARINVT.BKAR_INVT_DATE}) < 25 then 1 else 2
 
I've got to learn how to use declared variables.