Date/Time Formula

[PatKiernan]

HELP

Scenario: I have log data that records when any change has been made to an individual record with a date/time stamp.

Like 2/25/2003 12:00:00AM

Currently, I am retrieving multiple log entries (for each change to the record) for each record.

What I would like to see is only the latest date change only. Not the entire change history of the record, just the latest change based on the most recent date/time stamp.

Any help or ideas would be greatly appreciated.
PJK

 

[Madawc]

Try a running total, and specify maximum.

You could also add a test to remove anything that was to old, say < date (1995, 1, 1) or whatever suits you. Madawc Williams
East Anglia
Great Britain

 

[Naith]

If you group by RecordID, you could enter the following into your Group Selection Criteria;

{DateTimeStamp} = Maximum({DateTimeStamp},{RecordID})

or you could group by RecordID and place all your information into the group header, suppressing the Details section.

The first option is more efficient if you don't want to return excess rows.

Naith