sort posts entries by date

Hi,
You imported with a CSV?
If the CSV has a date it will place them in that order. If the CSV has not a timestamp, but a human readable date, it will do its best to make a timestamp of it.

Currently there is not yet the option to change the date of each entry in the editor. It is often requested, so it should be someday soon :).

Hello Marcel,

Thanks for anwsering me

No, what I did is manually entered a new message from the frontend and then modified the date of each message in PHPMYADMIN. I had to convert each one with a proper timestamp (I used an Excel function for that)

My first messages are in that order for now:
22 may 2001 at 2:40am min:
19 march 2000 at 11:31pm min:
1 november 1999 at 6:57pm min:
1 june 1999 at 8:20am min:
24 june 2015 at 5:40pm min:
2 april 2015 at 9:08pm min:
6 february 2015 at 6:28pm min:
2 july 2014 at 10:59pm min:
28 january 2014 at 11:43am min:

By default the order should be by date or by post id ?

What do you think causes the problem if it should be by date order ?

Cotp

Ah, then probably the date fields for the first ones need a zero before it. They have one number less, since about 2003.

Thanks very much Marcel this solved the problem !

I suspect there’s a bug here. The field in the database is a varchar, so that’s where the sorting goes wrong. It needs to be TIMESTAMP or something similar.