Hi Abu
Premise.
I use the datepicker to manage the dates.
I have this need.
In the database the dates have the format 'Y-m-d', so that is possibile to set the correct order, from the nearest to the farthest or viceversa
Instead in the grid and in the edit/add dialog, with the italian localization of the datepicker, have an italian format:
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d-m-Y', "opts" => array("changeYear" => true));
because my customer is an italian company.
But in the search dialog I would to have the same format of the database ('Y-m-d') so that is possible to set a correct interval of search.
Is it possible a solution?
Thanks in advance
It will use same 'd-m-Y' in search interval too … and it work normal.
You need to criteria in search dialog e.g.
1) date > '01-01-2005'
2) date < '01-01-2008'
Doesn't work.
If I choose, in the search dialog, a field data, the criterium equal and write in the field control an existing date the search returns all the records and the filter doesn't work.
If I ignore the datepicker calendar, that proposes me an italian format ('d-m-Y'), and I write, in the field control, a data in the format 'Y-m-d' then the filter works.
But this isn't good for my customer.
Another suggestions ?
Thanks in advance