Quicksearch with date fields

I’m trying to search on a date field through quicksearch in a grid, but it doesn’t work.
If you search separately for the date figures it does find.

Has anyone tried it?


Yes and it does not work in a normal way. As the quick search is a text field, it does not know what type of info you are putting in the quick search. That being said, you can try to insert a data info in the same way is in your table, like this:


And see if it works.

OTOH you can use this in your SELECT and try to use the QS in the normal way:

date_format(data_nascimento, “%d/%m/%Y”) as nascimento,

Adjust to your needs and see if it works.


I’ll try it.