Cannot create Customer with Date of Birth in Magento 2.1 (en_GB locale) #6323

JacobDrummond · 2016-08-24T14:44:24Z

Environment

Apache 2.4.17
MySQL 5.0.11-dev
PHP 5.6.15
Magento 2.1.0

Steps to reproduce

In System > All Users > User > [You], set the interface locale to English (United Kingdom):
Create a new customer. Make sure to fill in Date of Birth field:
Save Customer

Expected result

Customer saves without error

Actual result

"Invalid date" exception thrown:
Trying to save the new customer again results in a JS validation error:

Cause

The culprit is Date::inputFilter()
In my case, Date::inputFilter() accepts 08/24/2016 and returns 0,8/2,4/2,016
0,8/2,4/2,016 is not a real date in any locale, causing an exception to be thrown.

General locale issues in Magento 2.1

Changing admin locale from en_US to en_GB causes PHP date formats to change, but not JS date formats.
In the above example, the JS datepicker populated the field with 08/24/2016, despite the entire UI being in en_GB.

The text was updated successfully, but these errors were encountered:

sevos1984 · 2016-08-30T14:03:25Z

Internal ticket created MAGETWO-57835, thanks for reportng

…nterface locale is en_GB #6323

[South] Bugfixes - MAGETWO-58277 Saving category on catalog with 20k+ products is very slow (from 5mins till 1 hour) - MAGETWO-23764 Category/Product Indexer fails with mysql fatal on large catalog - MAGETWO-33568 Customer is redirected to "Compare Products" Frontend page if tries to remove a Product from comparing - MAGETWO-56512 Products created via REST API are not visible after enabling the product via scope = All Store Views - MAGETWO-55154 [GitHub] IndexerHandlerFactory: Indexer Object cast to String - MAGETWO-57835 [Github] Cannot save customer dob attribute if admin interface locale is en_GB #6323 - MAGETWO-57629 ACL not used on grid quick edits

slavvka · 2016-09-26T10:58:58Z

The issue has been fixed and delivered to develop.

JacobDrummond · 2016-09-26T11:13:15Z

@slavvka, thanks! :)

sopedro · 2017-04-28T10:51:42Z

In frontend the date works well, the issue is just in backend and with all dates. The reports don't work too.

JacobDrummond · 2017-04-28T11:05:18Z

@sopedro, Magento2 admin locale is a mess. See, for example, #7888, #9426, #8849.

These, and similar issues, are widely-reported but development seems to slow.

vherasymenko · 2017-05-10T14:27:45Z

Steps to reproduce:

Install Magento latest develop version.
Go to Admin side
System > All Users
Choose your user, then set Interface local to United Kingdom
Click "Save"
Click "Customers > All customers"
Click "Add new"
Fill all required fields
Choose birthday date "Today"
In email field enter already existed email address
Click "Save"
After error change email on non existing and click "Save"

AR: Displayed error about incorrect date
ER: Customer should be saved

Note: but after first saving date changed on other date automatically.

Emadis · 2017-06-10T10:49:44Z

Issue fixes 1 month ago. Thank you Le 10 juin 2017 14:03, "nitin700" <notifications@github.com> a écrit :

…

I am working on it.. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#6323 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AZPmOtHVSzLKV3Roklk-2wea3dLSBTCsks5sCmoDgaJpZM4JsFYc> .

nitin700 · 2017-06-10T11:26:06Z

@Emadis Thanks for the information.

…nterface locale is en_GB #6323

…nterface locale is en_GB #6323 - MAGETWO-70327 - functional test

…nterface locale is en_GB #6323 - add ability for filtering by time

…nterface locale is en_GB #6323

MAGETWO-69029: Remove obsolete link "Show more" on Dashboard page on Advance Reporting block MAGETWO-60352: [Github] Wrong error message in cart after entering invalid discount code #7230 MAGETWO-66510: Javascript error prevents adding/removing categories from existing catalog price rule condition MAGETWO-59207: Checkbox return to stock doesn't work if Automatically Return Credit Memo Item to Stock Yes MAGETWO-70201: Update Readme for Analytics modules. Final MAGETWO-57835: [Github] Cannot save customer dob attribute if admin interface locale is en_GB #6323

magento-engcom-team · 2017-09-20T22:31:33Z

@JacobDrummond, thank you for your report.
The issue is already fixed in 2.2.0

danharper83 · 2018-04-09T08:39:58Z

Still a issue for 2.2.3

Trying to set "Set Product as New From"

Message "Invalid input datetime format of value '31/05/2018"

JacobDrummond changed the title ~~Saving Customer with Date of Birth throws exception in Magento 2.1~~ Cannot create Customer with Date of Birth in Magento 2.1 (en_GB locale) Aug 24, 2016

pboisvert assigned antboiko Aug 25, 2016

veloraven added bug report Component: Customer Admin Panel labels Aug 30, 2016

sevos1984 added the Issue: Ready for Work Gate 4. Acknowledged. Issue is added to backlog and ready for development label Aug 30, 2016

sevos1984 assigned sevos1984 and unassigned sevos1984 Aug 30, 2016

mmansoor-magento pushed a commit that referenced this issue Sep 26, 2016

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

910b937

…nterface locale is en_GB #6323

mmansoor-magento pushed a commit that referenced this issue Sep 26, 2016

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

5632d2a

…nterface locale is en_GB #6323

slavvka closed this as completed Sep 26, 2016

JacobDrummond mentioned this issue Oct 21, 2016

DatePicker date format does not reflect user's locale #6858

Closed

This was referenced Dec 14, 2016

Date of Birth attribute gets weird format on page reload #7778

Closed

Admin Order Reports throw exception in en_GB locale #7888

Closed

janeblonde mentioned this issue Feb 2, 2017

Reports and date format #7037

Closed

ishakhsuvarov reopened this May 10, 2017

ishakhsuvarov added develop Release Line: 2.1 and removed 2.1.x labels May 12, 2017

ishakhsuvarov unassigned antboiko May 12, 2017

magento-team pushed a commit that referenced this issue Jul 5, 2017

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

009365d

…nterface locale is en_GB #6323

magento-team pushed a commit that referenced this issue Jul 5, 2017

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

75c9faf

…nterface locale is en_GB #6323 - MAGETWO-70327 - functional test

magento-team pushed a commit that referenced this issue Jul 5, 2017

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

a2bec20

…nterface locale is en_GB #6323 - add ability for filtering by time

magento-team pushed a commit that referenced this issue Jul 5, 2017

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

6a53f65

…nterface locale is en_GB #6323

magento-team pushed a commit that referenced this issue Jul 5, 2017

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

b938571

…nterface locale is en_GB #6323

magento-team pushed a commit that referenced this issue Jul 5, 2017

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

9a1ed3d

…nterface locale is en_GB #6323

magento-team pushed a commit that referenced this issue Jul 5, 2017

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

ffaeb19

…nterface locale is en_GB #6323

magento-team pushed a commit that referenced this issue Jul 5, 2017

MAGETWO-57835: [Github] Cannot save customer dob attribute if admin i…

fda448e

…nterface locale is en_GB #6323

veloraven marked this as a duplicate of #10233 Jul 24, 2017

veloraven mentioned this issue Jul 24, 2017

Invalid date when i add product in magento 2. #10233

Closed

magento-engcom-team added Release Line: 2.1 Issue: Ready for Work Gate 4. Acknowledged. Issue is added to backlog and ready for development bug report Component: Customer develop Issue: Format is not valid Gate 1 Failed. Automatic verification of issue format is failed labels Sep 11, 2017

magento-engcom-team added 2.0.x Fixed in 2.2.x The issue has been fixed in 2.2 release line labels Sep 20, 2017

magento-engcom-team added the Reproduced on 2.1.x The issue has been reproduced on latest 2.1 release label Sep 20, 2017

magento-engcom-team closed this as completed Sep 20, 2017

fluential mentioned this issue Nov 24, 2017

Non US locale post saving issue magefan/module-blog#109

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Cannot create Customer with Date of Birth in Magento 2.1 (en_GB locale) #6323

Cannot create Customer with Date of Birth in Magento 2.1 (en_GB locale) #6323

JacobDrummond commented Aug 24, 2016

sevos1984 commented Aug 30, 2016

slavvka commented Sep 26, 2016

JacobDrummond commented Sep 26, 2016

sopedro commented Apr 28, 2017

JacobDrummond commented Apr 28, 2017

vherasymenko commented May 10, 2017

Emadis commented Jun 10, 2017 via email

nitin700 commented Jun 10, 2017

magento-engcom-team commented Sep 20, 2017

danharper83 commented Apr 9, 2018

Cannot create Customer with Date of Birth in Magento 2.1 (en_GB locale) #6323

Cannot create Customer with Date of Birth in Magento 2.1 (en_GB locale) #6323

Comments

JacobDrummond commented Aug 24, 2016

Environment

Steps to reproduce

Expected result

Actual result

Cause

General locale issues in Magento 2.1

sevos1984 commented Aug 30, 2016

slavvka commented Sep 26, 2016

JacobDrummond commented Sep 26, 2016

sopedro commented Apr 28, 2017

JacobDrummond commented Apr 28, 2017

vherasymenko commented May 10, 2017

Emadis commented Jun 10, 2017 via email

nitin700 commented Jun 10, 2017

magento-engcom-team commented Sep 20, 2017

danharper83 commented Apr 9, 2018