Empowering World With Technology

Below Function is used in Pega for converting string date  12/31/2025   to   31/12/2025 FormatDateTime(toDateTime("12/31/2025"),"dd/MM/yyyy","Europe/Amsterdam","en_BE") Result =  31/12/2025

  @pxAddMessageToPage(Param.BGNameNotFound,Primary) Param.BGNotFound!="" Param.BGNameNotFound  = "Assessment(s) Missing  for " + Param.BGNotFound Param.SetError   =   @pxAddMessageToPage(Param.BGNameNotFound,Primary) ------------------------------------------------------------------------------------------------------------- !@IsInPageList(Param.BGLR,".pyLabel",ECBLTBGList.pxResults) ECBLTBGList                      HDFC-HDFCAuto-Work-RD ECBLTBGList.pxResults                 Code-Pega-List BGList                                   HDFC-HDFCAuto-Work-RD BGList.pxResults               Code-Pega-List

  Param.pxListSubscript   =  .pxListSubscript .pySelected =  "true" Param.DeleteSelectedRows  =  @Utilities.RemoveDeletedObjects(<PageList>) .pySelected=="true" .pyDeletedObject  =  "true" Param.DeleteSelectedRows    =   @Utilities.RemoveDeletedObjects(.CountryList)

  @replaceAll(.DeviationList(<CURRENT>).DeviationJustification,"\n"," ") @pxReplaceAllViaRegex(Param.RemovedLineBreak,"[^a-zA-Z]+"," " ") @replaceAll(.CountryList(<CURRENT>).CountryName,"\n"," ") @pxReplaceAllViaRegex(Param.RemovedLineBreak,"[^a-zA-Z]+"," ")

 Imp Note => In table name only underscores are allowed.  CREATE TABLE "<SCHEMA_NAME>"."<TABLE_NAME>"  ( "PXCOMMITDATETIME  TIMESTAMP(6), "PXCREATEDATETIME" TIMESTAMP(6), "PXCREATEOPNAME" VARCHAR2(128 BYTE), "PXCREATEOPERATOR" VARCHAR2(128 BYTE), "PXCREATESYSTEMID" VARCHAR2(128 BYTE), "PXINDEXCOUNT" NUMBER(18,0), "PXINDEXPURPOSE" VARCHAR2(255 BYTE), "PXINSINDEXEDCLASS" VARCHAR2(255 BYTE), "PXINSINDEXEDKEY" VARCHAR2(255 BYTE), "PXINSNAME" VARCHAR2(192 BYTE), "PXOBJCLASS" VARCHAR2(96 BYTE), "PXUPDATEDATETIME" TIMESTAMP(6), "PXUPDATEOPNAME" VARCHAR2(128 BYTE), "PXUPDATEOPERATOR" VARCHAR2(128 BYTE), "PXUPDATESYSTEMID" VARCHAR2(128 BYTE), "PYLABEL" VARCHAR2(255 BYTE), "PZINSKEY" VARCHAR2(255 BYTE) NOT NULL ENABLE, "PXSAVEDATETIME" TIMESTAMP(6) ); COMMIT;