Period Of Association Problem

[ashark]

I have Sales Data and have to find the 'Period' the Customers are Associated with the Company.
Data is as follows :

Customer1 01/01/2001
02/10/2001
01/11/2001
06/24/2002
12/25/2002

Customer2 03/01/2001
09/24/2002

I have to find the DateDiff of the first Date and Last Date.
But the a Customer can have many Lines of Data.
How can this be done?
How can I find the first Date and the Last Date and find its Difference?

 

[dgillz]

Group by Customer, then write a formula like this and place it in the group footer:

Datediff("d",Minimum({YourDateField},{Customer}),maximum({YourDateField},{customer}))

This will return the number of days difference between the minimum and maximum date for each customer. If you want something other than days, check out the help files for the various arguments you can use rather than "d" for days. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[ashark]

Hi dgillz
Thankyou very much.
It helped.

Regards,
ashark