How to sort dates with or without month

LOman · October 15, 2020, 9:08am

I have a column of dates in the following format:

September 1891
June 1829
1887
1917
March 1904
April 1904
1927
December 1892

Is there any way to sort them in date order?
Thanks.

Frants · October 15, 2020, 10:40am

It might be a good idea to keep the data in separate columns. Then the set can be sorted by any column.

LOman · October 15, 2020, 11:08am

How would that sort the dates?
Each Month belongs to the Year.
Ah, sorry, I think I see what you mean.
l’ll have a go. Thanks.

Frants · October 15, 2020, 11:16am

I can’t make the date format like yours. Can you send a fragment of your table?

LOman · October 15, 2020, 11:18am

Thanks Frants. Separating the columns works fine.

LOman · October 15, 2020, 11:20am

The months aren’t sorted correctly when the Year is the same but I’m not bothered about that.

LOman · October 15, 2020, 11:27am

Actually there might be a bug there because I set the Date column to format Date(MMMM) and it still didn’t sort them correctly when the Years are the same.

AlexKemp · May 27, 2021, 11:49am