Help

Sorting on DATE field is not working

651 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_Chiginsk
4 - Data Explorer
4 - Data Explorer

Hello I have a table which has three months of weather related data now. It is GROUPED on MONTH, it I have sorted it on the DATE field which is MMMM, DD, YYYY… PROBLEM - IT PUTS FEBRUARY FIRST no matter what I do.

Thanks
Tom

1 Reply 1

Welcome to the community, @Thomas_Chiginsky! :grinning_face_with_big_eyes: Could you provide more details on the field types for each of the fields that you’re referring to? I can’t tell which are date fields and which may be formulas. If you do have formulas, please list what those are in full.

My gut feeling is this: if you’re sorting/grouping based on a formatted date—i.e. a formula that outputs a display-friendly date in “MMMM DD, YYYY” format—then that might explain the odd order. That formatted date is no longer a date. It’s a string of characters, so sorting/grouping will work alphabetically based on the first character in the string.