App Connect

 View Only
  • 1.  issue with App connect

    Posted Tue August 22, 2023 09:33 AM
      |   view attached

    I am using IBM ACE v12.7. I am converting DATE into CHAR. I am supposed to get date in 08-Sep-2022 format while giving input as 08-09-2022.

    But I am getting 08-Sept-2022 when I am deploying the service in other system. Kindly help to resolve this issue. I have attached zip file of the same.



    ------------------------------
    Abhishek Jagtap
    ------------------------------

    Attachment(s)

    zip
    DateDemo.zip   2 KB 1 version


  • 2.  RE: issue with App connect

    IBM TechXchange Speaker
    Posted Tue August 22, 2023 12:03 PM

    This looks like the same issue (to do with a change in behaviour in newer versions of the ICU library which ACE uses) : https://www.ibm.com/support/pages/apar/IT41966



    ------------------------------
    Ben Thompson
    IBM UK
    ------------------------------



  • 3.  RE: issue with App connect

    IBM TechXchange Speaker
    Posted Tue August 22, 2023 12:29 PM

    This snippet using REPLACE function may also be helpful as a quick means of fixing:

            SET Environment.Date = CAST(InputRoot.JSON.Data.Date as DATE FORMAT 'dd-MM-yyyy');
            SET OutputRoot.JSON.Data.DATE=REPLACE(CAST(Environment.Date AS CHAR FORMAT 'dd-MMM-yyyy'),'Sept','Sep');



    ------------------------------
    Ben Thompson
    IBM UK
    ------------------------------