So I tried to use IF ELSE but I don't think I used it right because I get an error. Not even sure if this is close:
Code:
TTITLE 'RobAir - Pilot Proficiency Test Status'
COLUMN pil_pt135_date -
HEADING 'Last Proficiency Test'
COLUMN req_pt135_date -
HEADING 'Next Proficiency Test'
SELECT (e.emp_fname ||' '|| e.emp_lname) Pilot, p.pil_pt135_date
FROM hartmar.employee e join hartmar.pilot p on e.emp_num = p.emp_num
WHERE p.pil_pt135_date < (CURRENT_DATE - 180)
IF p.pil_pt135_date < (CURRENT_DATE - 180)
THEN req_pt135_date = 'OVERDUE'
ELSE req_pt135_date = DATEADD(mm,6,p.pil_pt135_date)
;