pears.MasterRosterMakeDate

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

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
}
  • database/procedures/pears_masterrostermakedate.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1