I have a requirement to fill one column with a 3 digit code based on few conditions.
I am trying if then else statement/case in calculated column in graphical view. I searched in the forum but I am not able to identify the right thread which solves my problem.
I have these date columns in my project node - 0POS_DATE , 0PSTNG_DATE, 0DUEDATE
based on the fileds following is the logic I am trying to implement. Please guide me.
When "0POS_DATE" <> '00000000' Then '231'
When "0PSTNG_DATE" = '00000000' OR TO_DATE ('2018-09-01') < "0PSTNG_DATE" Then '723'
When "0DUEDATE"='00000000' OR TO_DATE ('2018-09-01') <= "0DUEDATE" Then '654'
When DAYS_BETWEEN("0DUEDATE" , TO_DATE (2018-09-01')) > 100 Then '211'