`CASE WHEN ({custbody_delivery_date_schedule}) &gt...
# general
k
CASE WHEN ({custbody_delivery_date_schedule}) >= CURRENT_DATE THEN to_char({custbody_delivery_date_schedule},'DAY') WHEN {custbody_delivery_date_schedule} < (CURRENT_DATE - 1) THEN '<p style="font-style:bold;background-color:#ff8585;text-alight: center;"><img src="<https://3653670.app.netsuite.com/core/media/media.nl?id=4730410&c=3653670&h=XTIr2DuHjTYC1ci3yb92DP7UDQK13gkC9oUOysmmLMpJd9a_>"> END