I have about 3,500 posts (from a book, not previously blogged) to bring into WordPress. As a trial I've been using the RSS import which has worked fine.
I MUST sort the posts by date, but because they have come in via RSS, the date for all the posts is the time of the import.
I could sort by title but the title is an alphabetic pseudo date - 21 December 1945, 05 December 1972 and so on. So the output title is also alphabetic and 05 Dec 72 would come before 21 Dec 45.
I can't sort by ID, because that can be out of sync with the date for any number of reasons..
I guess I could write some SQL to update a field, but which one (post date, modified date)??
All suggestions (and solutions) gratefully received.