Need help with Max date, date difference

[ld66]

I have a report that calculates the last time a report was submitted and the last event that was logged in the report. For example:

Contact Report Submitted Last Event

A 8/1/04 7/15/04
B 8/15/04 4/15/04

I need to determine the number of days between the Last Event and The Report Submitted. Both fields are summary fields (max report submitted and Max last event).

I am using Crystal 9. Thanks!

 

[Madawc]

DateDiff("d", date1, date2) ought to do it. I've not tried using it with summaries, but if it refuses to use them, create running totals with the [maximum] as the type of summary.

Madawc Williams (East Anglia)

 

[ld66]

Thanks! I tried the first and it gave me an error, but the running summary worked. Thank you!

 

[lbass]

You should also be able to use the following:

datediff("d",maximum({table.reptsub},{table.groupfield}),
maximum({table.lastevent},{table.groupfield}))

-LB