Sorting on DATE field is not working

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.


Welcome to the community, @Thomas_Chiginsky! :smiley: 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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.