IF then problems...

[jacqu3sy]

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.

[paulbannister]

Hi There, try it simply as:

| eval finalclosedtime=if(status_label="New", stringtopopulate, closedtime)

[jacqu3sy]

Also worked, thanks!

[dineshraj9 · Accepted solution]

You can form the field this way -

| eval finalclosedtime=if(like(status_label,"%New%"),stringtopopulate,closedtime)

[jacqu3sy]

Thats so simple, took me ages trying to get that working! many thanks!

[DalJeanis]

Great! Please accept the answer that solved the problem, and upvote any other answers that you found particularly helpful.

[dineshraj9]

no problem 🙂