Skip to Content
0
Former Member
Feb 02, 2016 at 09:56 PM

How to calculate days between corresponding to a specific date

72 Views

Hi All,

I have the following table structure in my database:


Customer No. Status Date

123 1 01/01/2016

123 2 01/05/2016

123 3 01/11/2016

123 1 01/15/2016

123 5 01/21/2016

123 3 01/25/2016

I want to be able to calculate the days between when the Status changed from '1' to '3' for a specific customer.

In the example above, the status changed from '1' to '3' twice from 01/01/2016 to 01/11/2016 and then from 01/15/2016 to 01/25/2016.

Hence the days would be 11 + 10 = 21 days.

Will it possible to calculate this using a formula in crystal reports?

Thanks