Date and Time Column not Sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-3044610%22%20slang%3D%22en-US%22%3EDate%20and%20Time%20Column%20not%20Sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3044610%22%20slang%3D%22en-US%22%3E%3CP%3EWhile%20using%20a%20SharePoint%20List%20I%20can%20not%20get%20the%20Date%20and%20Time%20column%20to%20sort%20correctly.%20It%20was%20working%20before%20but%20now%20some%20times%20are%20out%20of%20order.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20hand%20entering%20the%20the%20date%20with%20the%20date%20picker.%20The%20list%20view%20setting%20also%20automatically%20sorts%20the%20Date%2FTime%20Column%20by%20ascending%20by%20default.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnly%20a%20couple%20lines%20are%20out%20of%20order%20and%20I%20can't%20seem%20to%20figure%20out%20why.%20I've%20deleted%20them%20and%20recreated%20them%20but%20the%20error%20still%20occurs.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3044610%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20List%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

While using a SharePoint List I can not get the Date and Time column to sort correctly. It was working before but now some times are out of order. 

 

I am hand entering the the date with the date picker. The list view setting also automatically sorts the Date/Time Column by ascending by default. 

 

Only a couple lines are out of order and I can't seem to figure out why. I've deleted them and recreated them but the error still occurs. 

 

 

 

 

4 Replies

@Bogdanofff Can you show us the screenshots of list view settings and the rendered list view with out of order date values?

It will be easier to answer your question more precisely by looking at the screenshots.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@ganeshsanap 

Bogdanofff_0-1640708489010.png


So this view is from looking at all items and filtering the Meeting Date & Time Column by 12/22/2021. The last two entries for some reason won't sort in order. I know there are a lot of variables at play but I'm not sure if this is just limitation brought on by filtering a column. Even after clicking sort by ascending or descending for that column it remains in the same order.  I have tried deleting the entries and reentering them using the Calendar and Clock and they still won't sort. 


A work around for now was creating a calculated column that reads the Meeting Date &  Time column and converts the value from 12/21/2021 2:15 PM to 12/21/21 1415. I then sorted by this calculated column and things are in order. 

 

Here is the formula used: =TEXT([Meeting Time]," mm/dd/yy hhmm.

 

Lastly, just to be sure, I created an index for the Meeting Date & Time column just to be sure things were not bugging out due to the list size. I also referenced this Microsoft doc: Manage large lists and libraries (microsoft.com)

 



@Bogdanofff Did you apply sorting on any other column in same list? If not, I think this is a bug from Microsoft side and you should report it to them by raising support ticket from admin center.

 

Btw, nice workaround to create calculated column and apply sorting on it.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Thank you!

Sorry for the delay but I was away from the Office! I think you are right.

No other columns were being sorted. Now this happened while on a custom view with a Ascending Sort on the Date & Time column while filtering by date. A lot of things happening.

This workaround has held up for the user but it must be bug or something