How to Create Function PeopleCode of PeopleSoft
Create Function in Record Field Formula (Record.Field)
/********************************************************************
Create Function
********************************************************************/
Function Set_DATE_Format_Number(&DATE_IN, &DATE_OUT)&DATE_OUT = Right(to_char(&DATE_IN,’dd/mm/’)|to_char(to_number(to_char(&DATE_IN,’yyyy’))+543));
End-Function;
How to Call Function in PeopleCode
Declare Function Set_DATE_Format_Number PeopleCode Record.Field FieldFormula;
Set_DATE_Format_Number(sysdate,&DATE_OUT);