Grouping for Date but show concatenate text string

[FaCe]

I've a table view that is grouped by Date 27/3/2023

I'd like to show Date in my native language (italian) as Lunedì 27 marzo 2023

as i've done elsewhere (i.e. in detail views)

using 2 virtual tables VTGiornoSettimana and VTMese

CONCATENATE ([VTGiornoSettimana], " ", TEXT([DATA], "d"), " ", [VTMese], " ", TEXT([DATA], "yyyy"))

How to achieve the same result in Table view leaving the grouping by date but changing date with my italian string concatenation ?

[TeeSee1]

Grouping by a VC is not an issue. Just select that column in the view definition.

The problem is that the converted "date" that you use to group the data by is now a Text and sort order becomes something that you do not expect. I do not know how you can work around that except maybe prepending it with something like TEXT([Date], "yyyymmdd").

Others may come up with more elegant solutions.

[FaCe]

Jus wonder if there's a solution for that ...