I have the following use case: Project A Project B, linked by Issue to A Project C, linked by Issue to A
First setting a date on B a date field of A must be set. Then when setting a date on C it must update the date on A if its date is newer.
I thought first of copying within a transaction of B the date from A to an Ephemeral field and compare then the both dates. But there is no such field like 'Ephemeral Date'.
Is there another solution?
PS: I could do it vice versa and get the newst date. But that is too late, so it must be triggered on B and C.