This content has been marked as final. Show 2 replies
I got my answer myself!
the person's most recent favourite job date = InstanceMaximum(the person's favourite job, the job's end date)
the person's most recent favourite job = InstanceValueIf(the person's favourite job, the job name, the job's end date = the person's most recent favourite job date)
Let me know if any other way exists to achieve the same result.
Just be aware that if you had two jobs ending at the same time, then InstanceValueIf would return uncertain (perhaps they had two jobs at the same company...?) so just make sure you handle that.
consider renaming the relationship to the plural... "the person's favourite jobs".
I am assuming that your system only handles jobs that have ended, as things would be much more complicated if they could have multiple jobs (which could overlap) or jobs with start dates that haven't ended yet.