Unparseable Date Error When Using parseDateTime on API Expiry Date
0
I am integrating with an API that returns voucher stock details, including an expiryDate field. The API response looks like this: "expiryDate":"9/8/2030 12:00:00 AM" In my microflow, I try to format this field: formatDateTime(parseDateTime($FirstStock/ExpiryDate, 'M/d/yyyy h:mm:ss a'), 'd/M/yyyy h:mm a') On some environments and users it works, but for others it fails with the following error: Error: Unparseable date: "9/8/2030 12:00:00 AM" I am on mendix 9.24 . My questions are : Why does Mendix fail to parse this date string even though the format seems to match? Could this be related to locale, time zone, or JVM regional settings? What is the best way to reliably handle API dates in this format (M/d/yyyy h:mm:ss a) across all environments?