How to setup the search date format
When I try to search a datetime / timestamp value (for example 2023-01-01 00:00:00) and I show the Date as d.m.Y, the date are not searchable in the search field as d.m.Y only as Y-m-d. How to setup the search format?
1 Reply
The search will use the value as it's stored in the DB, not the formatted value in the column.
I'm not sure but maybe you can explore a virtual column, to handle the formatting in the DB and make it searchable:
https://kirschbaumdevelopment.com/insights/leveraging-virtual-generated-columns