Date column won't sort properly


#1

Hello Panorama helpers. I have a file with a date column that does not sort properly. Has anybody ever seen this? Am I doing something wrong?

I found the problem. Somehow a summary record must have been added. I have no idea how such a thing could have happened, since I have never intentionally created a summary record. In any event, I ran a RemoveSummaries statement, and sure enough my file shrunk by one record. The date column now sorts properly.


#2

FWIW: If you want to group and summarize dates in a Date field, you should set a checkmark in the Panorama X preferences at “Allow grouping numeric fields”.