Set product as new "from" and "to" not being interpreted correctly

[gwharton]

Preconditions

1. Magento 2.1.8 CE
2. Locale set to GB

Steps to reproduce

1. Create product
2. Set product new from and new to dates to be 1st Aug 2017 to 1st Sep 2017

Expected result

1. Product is listed as new in "New products Widget" if viewed during August 2017

Actual result

1. Product is not listed as new in "New products Widget"
2. Set product new from and new to dates to be 8th Jan 2017 to 9th Jan 2017
3. Product is listed as new in "New products Widget" if viewed during August 2017

Looks like month and day have been interchanged.

You can also get an error when you try to set a date like 31st Aug 2017, which it says is invalid. Presumably trying to set the 8th day of the 31st month.

May be GB specific due to having date specification dd/mm/yy instead of the US mm/dd/yy

[orlangur]

GB locale is not builtin https://github.com/magento/magento2/tree/develop/app/i18n/Magento, is there a publicly available link to the one you used?

[gwharton]

Hi,

php bin/magento setup:static-content:deploy en_GB en_US

Under the admin pages, click arrow next to username in top right->Account Setting-Interface Locale->English (United States)

Product->Misc->Set Product New From ->Use Calendar and set 31st August 2017.
Product->Misc->Set Product New To->Use Calendar and set 30th September 2017.

Save Product OK, No error.

Under the admin pages, click arrow next to username in top right->Account Setting-Interface Locale->English (United Kingdom)

Product->Misc->Set Product New From ->Use Calendar and set 31st August 2017.
Product->Misc->Set Product New To->Use Calendar and set 30th September 2017.

Save Product -> ERROR Invalid input datetime format of value '31/08/2017'

[orlangur]

@gwharton thanks, I was not aware en_GB was always there, just without separate translation files.

[oleg-onufer]

Hi @gwharton.
Thanks for reporting this issue.
Internal ticket MAGETWO-71938 was created.

[sinamiandashti]

also happens on fa_IR
plz fix this

[gediminaskv]

I have date problems also on lt_LT. Actually I can not save correct date. The date field shows 201717-08-30 instead of 2017-08-30 after page reloads. And when I look to the database I see 1717-08-30.

Change locale to en_US fix this issue as suggested by #10485 (comment)

[dpaleino]

Duplicate of #10472 ?

[glaucomorais]

This is happening with pt_BR language too.
The calendar and/or the field is not respecting locale settings?