CASE WHEN {shipdate} < {today} +8 THEN 1 ELSE 0...
# general
m
CASE WHEN {shipdate} < {today} +8 THEN 1 ELSE 0 END