Search results for query: *

Ah..nevermind. It's too early. It appears to be working correctly.

Well this doesn't appear to be working correctly because I'm getting some weird output and I'm having to correct some of the formula. In your second formula: Whileprintingrecords; NumberVar total_days; total_days := DateDiff("d", BeginDate, EndDate); when I tried to save, I just get an error...

Thanks very much LB. I'll give this a go some time tomorrow and report back...much appreciated!

122 Complaint Opened 05/12/2008 122 Complaint Opened 05/12/2008 122 Complaint Opened 05/12/2008 122 Investigation Opened 06/03/2008 122 Investigation Opened 06/03/2008 122 Investigation Opened 06/03/2008 122 Investigator Reassigned 07/09/2008 122 Investigator Reassigned 07/09/2008 122...

moved the datediff formula to details and this is what I'm getting now: Complaint Opened: 05/12/2008 2 2 2 Investigation Opened: 06/03/2008 2 2 2 Investigator Reassigned: 07/09/2008 2 2 2 Investigation Complete: 12/10/2009 2 2 2 Admin Review Complete: 01/04/2010 2 2 2

I will post details in a bit. I would expect to see 22 for the first record because that's how many days it would have had the 'complaint opened' status: 6/3/2008 - 5/12/2008 = 22 days

I have this in CR2008: Group1: Complaint Number Group2: Status Date Group3: Status Details: Suppressed I have Group 2 Name in the Group 3 header and the group 2 header is suppressed. What I need is: Complaint Number: 122 (status) (status date) (number of days in status) Complaint Opened...