Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi,
I got a column with string dates (January, February etc...). Problem when I want to sort this dates, it's not a chronological but alphabetical order. How could I do to have first january, then february etc.
Here is my code
->pipe(new Group(array(
"by"=>"Date",
)))
->pipe(new Sort(array(
"Date"=>"asc"
)))
->pipe($this->dataStore('date'));
Thanks a lot
Hi Arthur,
Beside "asc" and "desc" directions, the Sort process could use a custom function as well. For your case please use the following code:
->pipe(new Sort(array(
"Date"=>function($m1, $m2) {
$map = array(
'January' => 1,
'February' => 2,
...
'December' => 12
);
return $map[$m1] < $map[$m2];
}
)))
Hope this helps. Thanks!
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo