AnsweredAssumed Answered

Calculation to get most recent status for a log of records

Question asked by NicoleHartman1367 on Jul 21, 2011
Latest reply on Jul 21, 2011 by philmodjunk

Title

Calculation to get most recent status for a log of records

Post

Hi,

I am trying to create a calculated field that gives me the most recent status for a record.

I have a log of records that each have an ID, the ID can be duplicated in the database many times with different statuses which have a timestamp to them.

I want to be able to create a calculated field that indicates that that perticular record is the most recently created status for a given ID. 

How would I go about doing this? The field would need to be such that it would constantly update as new records are logged.

Thanks!

Nicole

Outcomes