Calculating days between records

[merlyn383]

I have multiple records that contain a field "status" with values such as "Status 1", "Status 2", "Status 3", etc and also contain a date field. The primary key for the database is a concatintion between of "Item ID" and "Status". I want to calculate the number of days it took for a particular item to chang from Status 1 to Status 2 and I'm oping to do this in a field definition rather than a script, any ideas?

[mr_vodka]

I believe that you can use some of the techniques demonstrated here and then use a calc field to determine the difference between teh two related record dates.