0

using a pivot with formatted date as column doesn't sort

We are trying to use a friendly formatted date (MMM dd, yyyy) as the column in a formula. This works fine. However, no matter what is put in the sort by bubble, the columns are sorted in alpha order. If the default date format (yyyy-MM-dd) is used, it sorts fine.

The formula for the column is simply:

formatDate(dateField, "MMM dd, yyyy")

It seems to be a general issue in sorting a formatted date formula. Is there a way to work around this?

As an enhancement, it would be helpful to be able to format the display for rows and columns without the need for a formula.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 1 mth agoLast active
  • 15Views
  • 1 Following

Product Announcement

Incorta 5 is now Generally Available