date minimum and maximum

[goat9]

I have a date field that and all I want to do is find the difference between the earliest date and latest date, I don't want to use any of the dates in between.....how do I accomplish this task?

 

[RJFost]

By default, CR does date math in terms of calendar days. So all you need is a formula field:

{<end date>} - {<start date>}

It'll return the # of days between the two values.

 

[GMcNamara]

I would assume you will have to find the earliest and latest dates before you do the calculation.

maximum(TABLE.DATE_FIELD) - minimum(TABLE.DATE_FIELD);