case to_char({date field}, 'D') when 4 then {date field} +4 when 5 then {date field} +6 when 6 then {date field} etc.