Date diff calc

[JosephLaz]

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 EventDate 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.
Thanks

 

[synapsevampire]

Ahhh, repeating the same post without the requested clarification I see.

So you only want to compute between events 7 and 3, he asked again...

-k

 

[lbass]

Yes, it is a repeat, and I think my suggestion in the earlier post should have worked. How about some feedback in the original post? If it didn't work, you should explain the results you got, and why they didn't meet your needs, so the solution could be adapted accordingly.

-LB