I am using Magento 2.2.8 version.
The order grid is not giving the correct results on filtering by purchase date. It works with English (US ) value of fileld Interface Locale in admin account settings.
My locale is Tiếng Việt (Việt Nam) / Vietnamese (Vietnam).
Can anyone help me solving the filter result issue on order grid for my locale.Looking forward for a solution
Could you please share the screenshot what is the actual problem?
As I have tried with the Vanilla version of Magento by locale setting change and it working well with both the language.
Please give more details so it helps us to troubleshoot the issue.
Here is the scenario
1)Login to Admin backend and change the Interface Locale toTiếng Việt (Việt Nam) / Vietnamese (Vietnam) from Account settings
2)Go to Sales Order Grid
3)Filter order by purchase date,It will return wrong results .
a)Try filter Purchased date from “31/03/2020” => the result is incorrect (respond all orders from beginning)
b)Go to Order grid, filter Purchased date from 01/04/2020, the result show correctly
When i looked for solution,many have mentioned similar issues related to differnt locale (Dutch).Some of them answered the date format issue in the filter.But not a proper solution is found.
I tried the same in default setup,there also the issue exist.So i am afraid whether its a core bug.
Looking forward for the solution
Yes, you are correct - In Tiếng Việt (Việt Nam) / Vietnamese (Vietnam) language its not working well.
Though we put specific date range in the top filters it's not giving correct result - so your issue is correctly reproducible.
For the solution will troubleshoot the issue more and share if any solution found.
@Manthan Dave Did you get time to spend on this issue.
Shall I have any updates from your end regarding this.