Hi,

I am in the process of creating a report that will report the number of permits that have met date event milestones. Each permit has a number of milestones to meet (example below) and the dates are calculated using the dates in the EventDesc column. The question I have is this: Using the example table and data below, how can I calculate the date difference (in days) between say EventDateID (7) and EventDateID (3) :

PermitID    PermitNum   EventDate   EventDesc   EventDateID
---------------------------------------------------------------------------------
23               PSD-1206      5/11/06     App Received             1
23               PSD-1206      5/25/06     Determination            2
23               PSD-1206      7/25/06     Complete App Rec      3
23               PSD-1206      8/25/06     Process                      5
23               PSD-1206      9/25/06     Disclosure                  6
23               PSD-1206      11/22/06    Final Decision            7

I tried using the PreviousValue function, but that only allows calculation between the record previous to it like EventDateID (7) and (6) above. I am using Crystal Report version 10, SQL Server 2000 as backend DB and stored procedure.
Thanks