AC-18128: GraphQL order dates and comment timestamps are incorrect for non-English locales
The AC-18128 patch fixes the issue where order dates and order comment timestamps returned by GraphQL can display incorrect calendar dates in non-English locale settings. This patch is available when the Quality Patches Tool (QPT) 1.1.83 is installed. The patch ID is AC-18128. Please note that this issue was fixed in Adobe Commerce 2.4.8.
Affected products and versions
The patch is created for Adobe Commerce version:
- Adobe Commerce (all deployment methods) 2.4.8
Compatible with Adobe Commerce versions:
- Adobe Commerce (all deployment methods) >=2.4.8 <2.4.8-p6
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
Order dates and order comment timestamps returned by GraphQL can display incorrect calendar dates in non-English locale settings.
Steps to reproduce:
-
In the Admin panel, go to Stores > Configuration > General > Locale Options. Set Timezone to Europe/Paris. Set Locale to French (France). Save the configuration.
-
Place an order on the storefront.
-
Execute the following Customer Orders GraphQL query:
code language-graphql query getOrders { customer { orders { items { orderDateOK: created_at orderDateFAIL: order_date } } } }
Expected results:
Order date and comment timestamps in GraphQL responses reflect the correct calendar date, regardless of store locale.
Actual results:
For non-en_US locales such as fr_FR and de_DE, order_date shows the wrong calendar date because of a date parsing issue.
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