recurring payments calculations
I am trying to set up a recurring payments system.
I have set up the following fields:-
What calculations can I use to calculate nextInvoiceDate and lastPaymentDate??
Some sort of date function I imagine.
Could anyone also recommend how I can automaticallly add a recurring payment thats payable to an invoice table?? Perhaps using a script that runs every day on the server (we have filemaker server 10)
Many thanks for your kind help.