kauakea
asked on
incrementing months
i want to set up a table that will hold a payment plan information. basically:
id no.
start date: 06/01/06 (global)
original amount: $300.00 (global)
payment day of month: 15
Amount of Payment: $100.00
i would like to know if there is a way that i use a loop to populate the records for an id no. by putting in the information and having it go through and set up the payment plan until it hits the original amount?
example
Date Amount
6/15/06 $100.00
7/15/06 $100.00
8/15/06 $100.00
id no.
start date: 06/01/06 (global)
original amount: $300.00 (global)
payment day of month: 15
Amount of Payment: $100.00
i would like to know if there is a way that i use a loop to populate the records for an id no. by putting in the information and having it go through and set up the payment plan until it hits the original amount?
example
Date Amount
6/15/06 $100.00
7/15/06 $100.00
8/15/06 $100.00
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't add a number of days, use FileMaker's date functions to increment just the date portion by one month.
Like this:
MyDate = Date ( Month ( MyDate ) + 1; Day( MyDate ) ; Year( MyDate ) )
Like this:
MyDate = Date ( Month ( MyDate ) + 1; Day( MyDate ) ; Year( MyDate ) )
the beauty of this function is that it controls over/underflow itself. if you set january - 1 , it automatically decrement thes year and set the month to december, so you never care about anything else but months. same thing applies to days (to find last day of the month, use date ((1st day of next month) - 1). quite good for invoices due dates...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER