Creating an Aging View ??

Cool Aj ! I have a different version as you said.  If required i could send him.

Andrew, the refresh button won't show when you use
   @TextToTime("Today")
instead of
   @Now

;-)

yea, but then the view isn't up to date unless he manually refreshes.  He does want an AGING view, so I presume that its date sensitive and he wants it to stay up to date.

Will This show headings ??  The view should like something like this:
>20 days, then the list of documents, then the total number.
11 - 20 Days, then the list of documents, then total
6 - 10 Days, then list documents, then total
2 - 5 Days, then documents, then totals.
The Status would be categorized twistie, then sub Days listings >20,11-20, 6-10, 2-5, categorized twistie then the actual documents then a total. ???
Not sure how to set this up ??
Thanks !!
 :)

Hello Andrew,
In reviewing the formulas you have established, I think their backwards.
OpenDate is thesame as a field I have called creationDate.  Therefore to test for aging over 20 days the formula should be something like:
@If(@Adjust(@Date(@Now); 0; 0; -20; 0; 0; 0) > CreationDate) then the document is greater than 20 days old. Am I thinking this correctly ???
I'm wondering how to have all of the formulas in 1 view.  I can create 4 different view, one for each aging period, nut I wanted to have 1 view with all four different aging periods and have the periods as the twistie category ??!!
<:-|

Ok... Here's what I have done:  I have created 4 views, 1 for each aging period.  The formula for the first 2 are:
>20 days the view selection formula is:
SELECT ((Form = "CSC Incident report") & 
(@Adjust(@Date(@Now); 0; 0; -20; 0; 0; 0) > Creation_Date_1)).
The second between 11 - 20 I have the formula as:
SELECT ((Form = "CSC Incident report") &
((@Adjust(Creation_Date_1; 0; 0; 11; 0; 0) <= @Date(@Now)) &
(@Adjust(Creation_Date_1; 0; 0; 20; 0; 0) >= @Date(@Now))) .
Am I on the right track with this ???  Also, this will work, but I wanted to have them on 1 view.
?!!?!

the concept is right, Pratigan.  No reason they can't be in the same view.  I'll look more closely when I'm home later tonight.  (I'm mobile right now in a hospital waiting room -- nothing critical).

Not another car accident I hope!?
(You ARE EE-addicted, aren't you?)

Just killing time at the hospital.  Waiting, waiting, waiting.   My wife had an appendectomy.  I've got this cool new 3G cellular "express net" card in my laptop.  It has a tiny little antenae that nobody notices, and I have two batteries to give me nearly 6 hours of live time.  Now I'm TRULY mobile.

Pratigan, I'm sorry I haven't had time to put that into a single view.  I'll try to get to it by monday afternoon.  The info is all there, it just needs a little more polish on it to make it clear.

btw: With Barb's surgery, I couldn't go as a member of the team for training, but I did take the kids to a training burn today.  Someone donated an old house that needed to be taken down, so we used it for practice:

http://www.thenorth.com/northern.nsf/html/wburn

--AP

Great Pictures..... Looked like a nice house.  
Thank you !
Paul
:-)

Hello All,
i have resolved this question with my previous posting.  I will still be granting points however for your efforts.  I'm going to grant 50 points to Andrew for his input and time.  I hope this is acceptable.  Thank you !
Paul
:)

And me ?

Points reduced from 100 to 50 per request

SpideyMod
Community Support Moderator @Experts Exchange

Arun... you are a point junky... I will be having points for you in my other posting with the 2nd notes error..
Thanks !!
:-)

Thats cool....