AnsweredAssumed Answered

Question on  status change based on date and one other criteria

Question asked by kazmerelda on Aug 6, 2018
Latest reply on Aug 13, 2018 by leif_jacobsen

Hi there,

 

We have some data where we have a status that needs to be translated into a new value.

 

The criteria is if the status is Open and the end date is in the future it is Live. If the status is Open and the end date is in the past, it would be Expired.

 

I have looked at the cross reference lookups and also an SQL lookup but wondered if anyone else had done something similar and is there an easy way to do this?

 

Thanks for your help!

Outcomes