Invalid date when customer validate with French locale

[vjacquemin-sqli]

Preconditions

1. Magento 2.1.5
2. PHP 7
3. MySQL 5.6

Steps to reproduce

1. Set Backoffice to French locale : account settings ->language French (France)
2. Modify a customer and set date of birthday (for example : 04/17/1973)

Expected result

1. Customer validation with new DOB

Actual result

1. Error message "Invalid date"

I found in Magento\Framework\Data\Form\Filter\Date class before line 65, the date value is okay, after the l.65, date value contains space chars. I think Zend_Filter_NormalizedToLocalized "filter" method insert spaces (as thousand separators). If I ignore this line, validation succeeds.

[gsomoza]

Maybe I misunderstood what you meant, but the string "04/17/1973" should NOT be a valid date in the FR_fr locale: France uses DMY for all-numerical dates. So if validation fails with "04/17/1973" then that's correct for the French locale.

[vjacquemin-sqli]

@gsomoza : You're right. The right date should be 17/04/1973 (dd/mm/yyyy). But javascript validation fails if I input '17/04/1973' (I obtain an error under calendar "Enter a correct date"). That's another Magento2 bug I suppose.

However, if I input '04/17/1973', Javascript validation succeeds, but PHP response fails, and I notice that space has been inserted in my date (as I explained on my additionnal informations on the issue above).

[gsomoza]

Great, this is clear now, it indeed looks like a bug 👍

[VasylShvorak]

@vjacquemin-sqli Thanks for reporting this issue. Created internal issue MAGETWO-70504 to investigate and track this issue.

[samuelecarpene]

Same problem with Italian locale.

[joachimVT]

Working on this issue.

[magento-team]

Internal ticket to track issue progress: MAGETWO-80096

[magento-engcom-team]

Hi @vjacquemin-sqli the issue has been fixed in #11067 by @joachimVT
The fix will be available in 2.2.1

[digvijay2017]

This issue is fixed in 2.2.1. Thanks

[okorshenko]

Hi @vjacquemin-sqli. Thank you for your report.
The issue has been fixed in magento-engcom/magento2ce#1353 by @magento-engcom-team in 2.3-develop branch
Related commit(s):

• 299109f
• 57318bf
• 41cd961
• 076b903
• 435a6c2
• 5d174b8
• a47b10d
• ab48cb1
• 46be4c7
• eafc6f0
• 63b9e90
• 2edfe9a
• ef5ddff
• 4ada797
• c5d9a01
• 72e9e07
• 215180d
• 685d506

The fix will be available with the upcoming 2.3.0 release.

[tinbrandon]

This issue is still happening in Magento 2.4.6 when saving customer birth day in none english date format.