Quicksearch with date fields

Scriptcase 9 Bugs
#1

Hello
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?

Regards.

#2

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:

2024-02-07

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.

Regards,

#3

thanks.
I’ll try it.