I have a simple table with 3 columns:
Date 1 containing dates
Date 2 containing different dates
ChosenDate containing either the value Date1 or Date 2.
For each record I would like to see a field called NewDate which is either Date1 or Date2 depending on the value in ChosenDate. Currently I tried $(ChosenDate) as NewDate but no luck. Any suggestions?
Thanks for the suggestion - it doesn't work however. The following error messages comes up:
Thanks both - unfortunately with the new dollar expansion I get the same error message. The if statement or alternative the pick(match()) both work but aren't ideal as actually I have Date1, ..., Date 20 not just 2 dates and so I was hoping to avoid a large nested if statement or a large pick match statement....