I'm trying to create a new column with a date according to values in another column. My conditianal formula is just giving me null values at the moment.
Can you see what I'm doing wrong?
IF Contains('3710_', [COURSE_CODE]) THEN '2017-02-27' ELSEIF Contains('3720_', [COURSE_CODE]) THEN '2017-07-24' ELSE NULL() ENDIF
Thanks in advance for your help,
DHB.
Solved! Go to Solution.
The syntax of the contains function is incorrect, it should be:
IF Contains([COURSE_CODE],'3710_') THEN '2017-02-27' ELSEIF Contains([COURSE_CODE],'3720_') THEN '2017-07-24' ELSE NULL() ENDIF