Table View with Group Aggregate "Date" with format MMM-YYYY?

[cboteros]

Hello everyone,

I think I know the answer already (“not supported”) but yet I want to ask.

This is somehow related to a previous question I had posted which was about how to format a Date column (see: Is it possible to display Date column values in a different format?)

At this point in my app, I have a table view that lists “EXPENSES”, and each row has a [Date] column.

I’ve created also a [Month] virtual column of type “Text” with this formula: TEXT([Date],“MMM-YYYY”) as it was the suggestion from the previous question (See link above). Also, this new virtual column is the “Label” for my table. The values in that column look like: “Jan-2021”, “Feb-2021”, “Mar-2021” and so on.

Then, I wanted to Group Aggregate the EXPENSES by this virtual column, but the issue that I have is that the group gets sorted “alphabetically” and not “chronologically”… (clearly, because the virtual column in the end is a “Text” and not a “Date”).

I’ve tried changing the type of the [Month] virtual column to be of “Date” type, and while in this case the sorting is correctly (chronological), the Group Aggregate instead of showing something like “Jan-2021” displays “1/1/2021”

So, my final objective would be to be able to have a Table with a Group Aggregate of type “Date” where the “Date” values in the Group Aggregate would be displayed in the “MMM-YYYY” format, while still keeping the “chronological” sorting.

Is it there any way to achieve this?