get newest related date

[RichardBurrow]

Hi all, hope someone out there can help...

I am working on a workflow management system. I have a table that stores job stages and a related table that stores time logs for each of the job stages.

for example a job may be created with a job stage "Design - Concept" and the operator may then log hours against that job stage on a few separate dates. I am stuck with producing a calculated field to evaluate all related timelogs and then returning the newest date for the related jobstage.

So if the operator logged time entries against job stage "Design - Concept" on 01-Apr-09, 04-Apr-09, and 05-Apr-09 I would want the calculation to return 05-Apr-09.

Thanks in advance for your help

[mr_vodka]

Assuming that you have a job table and the related loghours table:

You can use a 1 line portal sorted descending, a sorted relationship descending, or use a calc on the job layout that is max (loghours::date)

If you need to include multiple types of job stages for each job, then just remember to have that field as part of your relationship.

[RichardBurrow]

thanks! worked like a charm