Search doesn't work as expected for date fields

[scoumbourdis]

The search doesn't work as expected for any of the themes available so far for date fields at the column list. More specifically Grocery CRUD is experiencing the following problem :

When we search with our date format for example: 22/04/2017 we are expecting to get all the dates of 22/04/2017 instead no results are returned

The main reason for that is that we will need to search with the following format YYYY-mm-dd for example: 2017-04-22. But even then we will have issues as the quick search is mainly looking with a LIKE. For example you can search all of the dates on 2017 by writing 2017 or if you would like to search all the dates of March 2017 you should write 2017-03. This is not very obvious for the end user and it is a bit also annoying to explain this situation to a customer but this is the work-around for now.

We will try to fix this problem so it will at least search by the date format of the user.

[portapipe]

We are using European dd/mm/yyyy format and is should be good to have it working in that format.

There is the Boolean search that is not working as expected. We can take a look at it too.

[scoumbourdis]

Scheduled in my todo list to be done by: 30 June 2018 (without any promises)

[mbanolas]

Please, could you inform if the issue has already been solved? Thanks.

[mckaygerhard]

i do not use date formats.. just use YYYYMMDD and that's all.. too complicated for