Laravel Collection sortBy date (String) not working as expected

Hi Guys I found some strange behaviour when the data deleted, it not sort same as before

This is the actual data

Then after I delete the purchase id 4898 and refresh it become

$collection->sortBy('expiry_date')

Anyone know how this happend?

Level 75

You have to change string to date or int in this example:

$collection->sortBy(function ($item) {
    return strtotime($item->created_at);
});

1 like

Level 1

@michaloravec ok thanks for the answer, however I am just curious how this can happend :D

Level 75

Ok I now check those pictures and all of them have same date without time. So it can't know in which order they should be.

Better will be if you add next sortBy for example

$collection->sortBy('expiry_date')->sortBy('purchasing_id')

Level 1

Not working as I want, sorry

Please or to participate in this conversation.