Reeza, your answer seemed most appropriate, but I'm getting this error in the log. You can see my computed column syntax as well. For the record, I entered values for all of these prompts in the prior query, and they appeared to have passed through correctly, as evidenced by the '12Mar2013' date, which is correct. 465 /* LIFECYCLE BUCKETS */ 466 (CASE WHEN (t1.POL_EFF_DATE>=&BEGIN_LIFE_START AND t1.POL_EFF_DATE<=&BEGIN_LIFE_END) THEN "BEGIN LIFECYCLE" NOTE: Line generated by the macro variable "BEGIN_LIFE_START". 466 12Mar2013 ------- 22 ------- 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GT, GTT, LE, LET, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. 467 WHEN (t1.POL_EFF_DATE>=&MID_LIFE_START AND t1.POL_EFF_DATE<=&MID_LIFE_END) THEN "MIDDLE LIFECYCLE" WHEN 468 (t1.POL_EFF_DATE>=&END_LIFE_START AND t1.POL_EFF_DATE<=&END_LIFE_END) THEN "END LIFECYCLE" ELSE "" END) AS 469 'LIFECYCLE BUCKETS'n
... View more