pears.MasterRosterMakeDate
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."MasterRosterMakeDate" IS {CREATE FUNCTION MasterRosterMakeDate /* Application Maintained Function / Procedure - DO NOT EDIT*/ ( IN pstartdate DATE,IN pdays INTEGER,IN pgedate DATE ) RETURNS DATE deterministic BEGIN IF pstartdate IS NULL OR pdays IS NULL OR pgedate IS NULL THEN RETURN NULL END IF; SET pdays = abs(pdays); loop IF pstartdate >= pgedate THEN RETURN pstartdate END IF; SET pstartdate = dateadd(DAY,pdays,pstartdate) END loop END }