Mac OSX 10.5
I am trying to work out how to set up a field or fields that calculate how long a payment has been unpaid. eg 30 days, 30-60 days, 90+ days. It would be working off a global date field that calculates the current date when the my related files open using "InsertCurrentDate" in my open file script.
I have a related transaction file that generates transactions for each client but have no way of tracking how long a transaction has been unpaid for. This is known as "account ageing".
Any ideas on whether there are calculations that can be done in filemaker to put together a script that would calculate a result based on how many days/weeks have elapsed from the date when any given transaction was generated, since the current date? This would allow me to create a report every month. I can currently run a report of all transactions unpaid but cannot categorise them.