Previous | Next | (P-PDF) Acrobat 6.0

Topic: Need help with calculation on form (Via Email), 1 Attachments
Conf: (P-PDF) Acrobat 6.0, Msg: 115280
From: bstradling
Date: 7/13/2004 05:04 AM

I am having trouble figuring this out. I sure have a lot to learn. Anybody want to help? The following is the orginal calcs from a spreadsheet formula.

=IF(C4,(DAYS360(E1,C4,FALSE)*C2)+C1,IF(C1,C1,""))

where C1 is payoff balance
and C2 is the per diem
and E1 is the start date
and C4 is the ending date

The following was my attempt to code it but it is failing.

var MHPB = getField("MortgageHolderPayoffBalance");
var MHPBC = getField("MortgageHolderPayoffBalanceCurrent");
var MHPDate = getField("MortgageHolderPayoffDate");
var BCDate = getField("BuyerClosingDate");

if (MHPB == 0 || MHPB == null) {
MHPBC.value = 0
}
else {
var date2 = util.scand("m/d/yyyy", BCDate.value);
var cdate = util.printd("m/d/yyyy", BCDate.value);
if (cdate != "") {
var d2 = date2.valueOf();
var date1 = util.scand("m/d/yyyy", MHPDate.value);
var d1 = date1.valueOf();
var d3 = d2 - d1;
var days = d3 * 1000 * 60 * 60 * 24;
var MHPerDiem = getField("MortgageHolderPerDiem");
var payoff = days * MHPerDiem.value + MHPB.value;
MHPBC.value = payoff;
}
}

book1.zip
zip file with xls and pdf files (10,924 bytes)