AC-18096: Sales GraphQL date fields return an incorrect localized format
The AC-18096 patch fixes the issue where Sales GraphQL date fields return dates in a different format than previous releases by reverting the date format from slash-separated / to dash-separated -. This patch is available when the Quality Patches Tool (QPT) 1.1.83 is installed. The patch ID is AC-18096. Please note that this issue was fixed in Adobe Commerce 2.4.9.
Affected products and versions
The patch is created for Adobe Commerce version:
- Adobe Commerce (all deployment methods) 2.4.9
Compatible with Adobe Commerce versions:
- Adobe Commerce (all deployment methods) >2.4.8 <=2.4.9-p1
magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.Issue
Sales GraphQL date fields return date and time values in slash-separated format (d/m/Y H:i:s) instead of the dash-separated format (Y-m-d H:i:s) used in Adobe Commerce 2.4.8
Prerequisites:
- General > Locale Options > Timezone: Europe/Paris
- General > Locale Options > Locale: French (France)
Steps to reproduce:
-
Create an order.
-
Retrieve order date details using GraphQL:
code language-graphql query getOrders { customer { orders { items { orderDateOK: created_at orderDateFAIL: order_date } } } }
Expected results:
- The fields return values in
Y-m-d H:i:s, matching the output in version 2.4.8.
Actual results:
- The fields return values in
d/m/Y H:i:s, such as27/08/2026 14:12:55, instead ofY-m-d H:i:s, such as2026-08-27 14:12:55.
Apply the patch
To apply individual patches, use the following links depending on your deployment method:
- Adobe Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide
- Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide
Related reading
To learn more about Quality Patches Tool, refer to:
- Quality Patches Tool: A self-service tool for quality patches in the Tools guide