Calculation based on Date

[Brudders]

I am writing a bookkeeping application and would like to display balances outstanding for invoices overdue by 30 60 90 day periods.

What I would like to acheive is have 3 fields 30 60 90 which dynamically calculate balances based on age of invoice and result is balance of those invoices.

Can anyone point me in the right direction

[Computer Geek]

Brudders,

Check out the following example file. I think that it will answer your questions.

dateexample.zip

[Brudders]

Reply to computer_geek

Many thanks for the example it really helped with the date calculation, could you tell me the balance for invoice only calculated for that individual record how can I get balance fields for 30/60/90 days to calculate the whole table of invoices and give the total of all records.

Thanks again

[Computer Geek]

Brudders -- You do it with summary fields. You create a summary field and when you do, you specifywhich field to sum. It displays the sum for whatever found group you have selected.

I added attached a sample.

datepart2.zip

[Brudders]

Thanks for all your help, with your examples I was able to tailor and get required result for my app. Your help is very much appreciated.