Date Difference Between Records

[kinvie]

I think I may have lost some brain cells during the flood last week, so I am hoping someone will have mercy on me and help me calculate the difference between dates on records using Crystal 10.0 to connect to some Oracle tables.

I have date that is like this

May 2008 (group)
(Detail) Patient A onsetdate 5/22/2008
(Detail) Patient B onsetdate 5/24/2008

June 2008(group)
(Detail) Patient A onsetdate 6/07/2008

I need to calclate the number of days in-between each onset date. The answer in this case would be 2 and 14. In the end I would want to display the maximum of the 2 & 14.

I know I need to use varables but after that I losing ground. Any help would be greatly appreciated!!

 

[kinvie]

Thanks to anyway who was thining about help - I was able to get it to work using the previous function.

 

[Madawc]

With groups, you can also use summary totals for Max and Min. Often useful.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10