Syntax:!
CASE WHEN (expression 1) THEN value 1 WHEN (expression 2) THEN value 2 … etc … ELSE value n END
The parentheses around each expression must be included, and the END keyword as well.
The returned values in all cases should be of the same type.
Using the UEEF function, where AS OF date is field number [350005] we can ascertain if a passed date field occurs within the month specified by the As Of date, by using this case..when construct:
CASE WHEN (to_date(~,'DD-Mon-YYYY') between trunc(to_date(~[350005],'DD-Mon-YYYY'),'MM') and last_day(to_date(~[350005],'DD-Mon-YYYY'))) THEN 'C' ELSE 'P' END
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation