Solved

# Calculating Total Amount of future payments based on an expiration date.

Posted on 2004-04-01

I need to determine the total dollar amount of payments made from today to a contract expiration date.

The fields are as follows:

CTRCT_EXPIRATION_DATE

FEBRUARY_PMT

These are ongoing charges paid every month with no interest or increases involved. Just need to find out (based on the February Payment amount how much we will pay out from February up until the expiration dates of the contract for each record.

Please help! Need this ASAP for a meeting!

Thanks!