Aging Report

[shadar]

I know there are threads for this, but it seems like a lot of work for a simple calculation.

All I need to do is take current date subtract 30 days and have the records displayed. I think I will use a portal for that.

Looking to create 3 or 4 buttons with 30 60 90 and 120. Click on the button run the script. Is there anyway to take // - # of days?

Sorry I am from the Access world and this seems a little strange to me.

Sharon

[jteich]

- use a global number field for the value 30, 60 ...

- define two calculation fields

1. get( currentdate )

2. get( currentdate ) - global_30_or_60_or

- define portals relationship as

date <= calc_1 AND

date >= calc_2

jens