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
------------------------------
Original Message:
Sent: Tue August 22, 2023 06:01 AM
From: Abhishek Jagtap
Subject: issue with App connect
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
------------------------------