Actually, less is better: David Dillard wrote: Can anyone show me what I am doing wrong with this computed column case function? CASE t1.event_date WHEN (DATDIF(t1.event_date, DATE(), 'act/act')) GT 383 THEN 60 WHEN (DATDIF(t1.event_date, DATE(), 'act/act')) GT 383 AND (DATDIF(t1.event_date, DATE(), 'act/act')) LE 748 THEN 40 ELSE 0 END It runs, but only returns 0. When I do the DATDIF function in it's own computed column, I get the correct numerical return. Thanks What works is: CASE WHEN DATDIF(t1.event_date, DATE(), 'act/act') GT 383 THEN 60 WHEN DATDIF(t1.event_date, DATE(), 'act/act') GT 383 AND DATDIF(t1.event_date, DATE(), 'act/act') LE 784 THEN 40 ELSE 0 END However, I am now trying to add a prompt to the WHEN statement and can not get it to recognize the prompt. I have associated the prompt with the query, but when I add it to the WHEN line (WHEN DATDIF(t1.event_date, DATE(), 'act/act') GT 383 + &Prompt_offset GT 383 THEN 60), it flags the &. Any help is greatly appreciated.
... View more