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!