Last Payment Date

[jtr9999]

I am trying to find the last payment date. I can find the last payment date if the frequency of the payment is weekly or bi-weekly but I am having trouble finding the last payment date if the pay frequency is Semi Monthly or Monthly. I posted the equations I have for Weekly and Bi-Weekly. Does anyone have any suggestions on how to find the last payment date for if the frequency is semi-monthly or monthly? Thanks Jonathan

LoanDurDays
If {LOAN.PAYFREQCD}='W' THEN
(({EELOAN.PAYQTY}-1)*7)
ELSE IF {LOAN.PAYFREQCD}='B' THEN
(({EELOAN.PAYQTY}-1)*14)

LAST PATMENT DATE
{EELOAN.NEXTPAYDATE}+{@LoanDurDays}

 

[lbass]

Try a formula like this:


If {LOAN.PAYFREQCD}='W' THEN
({EELOAN.PAYQTY}-1)*7 ELSE
IF {LOAN.PAYFREQCD}='B' THEN
({EELOAN.PAYQTY}-1)*14
if {LOAN.PAYFREQCD}='M' then
({EELOAN.PAYQTY}-1) else
if {LOAN.PAYFREQCD}='S' then
({EELOAN.PAYQTY}-1)*2

LAST PATMENT DATE
if {LOAN.PAYFREQCD} in ['W','B'] then
{EELOAN.NEXTPAYDATE}+{@LoanDurDays} else
if {LOAN.PAYFREQCD} in ['M','S'] then
dateserial(year({EELOAN.NEXTPAYDATE}),month({EELOAN.NEXTPAYDATE})+{@LoanDurDays}+1,1)-1

This would give the last date of the month for monthly/bimonthly.

-LB