datediff, how do I make sure I have first and last date/time 1

[mgason]

Hi,
I do understand how to use datediff to get the difference between two date/time fields.
BUT I have a report which has returned a long list of date/times.
I have ordered those by time.
How can I write a formula that gets the diff between the earliest and latest date/time.

thanks
mark

 

[mgason]

Sorry forgot to say Crystal XI
also to be clear, the problem is making sure I have the first and last date/time to calculate the diff from.

 

[kskid]

datediff("d",Maximum({table.date),{table.fieldx}),Minimum({table.date},{table.fieldx}))

Not sure about the makeup of your group structure

 

[mgason]

that works just fine
thanks

 

[mgason]

if you have time check out my new post, continuation of the same problem

http://www.tek-tips.com/viewthread.cfm?qid=1525343&page=1