struggling with the following IF statement....
I have a table, and want to create a new field called 'finalclosedtime' which will be populated either by an existing field called 'closedtime' or a string IF one of the other fields contains a value of "New".
I tried this but no joy:
| eval finalclosedtime=if((status_label="New",stringtopopulate)closedtime)
Any ideas? Thanks.