Days between two dates

[garyaj]

Hi

I would like to be able to calculate the number of days that have passed between a new record and the previous one only and have that figure displayed in the latest record.

any advice as to the neatest way to do this?

Thanks as always.

[LaRetta]

Here is one way - Calculation (result is number)

Case ( theDate ; theDate - GetNthRecord ( theDate ; Get ( RecordNumber ) - 1 ) )

This does not require an additional table occurrence (simply to look backwards one record) so I like it.

UPDATE: I was a bit surprised to see that this calculation still produced a result, ie, -731143, when there was not a value in theDate EVEN IF 'Do not evaluate if all referenced fields are empty' is unchecked. So it requires a test for non-empty date first.

Edited August 19, 2008 by Guest
Added update

[garyaj]

Hi LaRetta

Thank you for your reply. I have been an idiot and forgot to mention something...on reflection VERY important.

I only want to calculate the days between subsequently created records for records that have the same CoID.

Sorry for being an idiot. All help appreciated.