Inserting a Date Column using a Formula

[DHB]

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.

[rahul1011 · Accepted 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