TO_DATE(NVL('~(gpv.rend;sqlText)', TO_CHAR((SELECT MAX(t.lastday) FROM terms t WHERE t.schoolid = ~(curschoolid) AND t.yearid = ~(curyearid)),'YYYY-MM-DD')),'YYYY-MM-DD')