CHANGE format DATA (examples "1-1-2018" to "January")

[DaGi07]

Hello,
I’d like convert the value of column type Data [Periodo] from “1-1-2018” to “January” (only month)
I tried with TEXT([Periodo]),“mmmm”) but it doesn’t work.

I tried also creating a new virtual column called “Month” with the following app formula but it doesn’t work when i group data in tables view
SWITCH(MONTH([Periodo]),
1,“Gennaio”,
2,“Febbraio”,
3,“Marzo”,
4,“Aprile”,
5,“Maggio”,
6,“Giugno”,
7,“Luglio”,
8,“Agosto”,
9,“Settembre”,
10,“Ottobre”,
11,“Novembre”,
12,“Dicembre”,
“”)

How can i change the format data correctly?
TKS

[SkrOYC]

DaGi07:

it doesn’t work when i group data in tables view

It should.
Post here your config

[DaGi07]

In the first screen I have used the formula SWITCH(MONTH([Periodo]),
1,“Gennaio”, 2,“Febbraio”,3,“Marzo”, 4,“Aprile”, 5,“Maggio”, 6,“Giugno”, 7,“Luglio”, 8,“Agosto”, 9,“Settembre”,10,“Ottobre”, 11,“Novembre”, 12,“Dicembre”, “”) but It’ doesn’t work because the second image is the detail of “Gennaio” and as you can see the total of Gennaio should be 21.622,32€ divided for each person

On the contrary, If i use the formula MONTH([Periodo]) the function “group by” works correctly

[SkrOYC]

DaGi07:

SWITCH(MONTH([Periodo]),> 1,“Gennaio”, 2,“Febbraio”,3,“Marzo”, 4,“Aprile”, 5,“Maggio”, 6,“Giugno”, 7,“Luglio”, 8,“Agosto”, 9,“Settembre”,10,“Ottobre”, 11,“Novembre”, 12,“Dicembre”, “”) but It’ doesn’t work

The expression works.

The problem is that you are not receiving the result you want using it on Group By.

Stick to the SWITCH() expression. We need to find out why the next view is not respecting it’s group.
Can you show us the UX config for that view?
Also post here your table’s schema (All the columns on that table and it’s column type)

[Koichi_Tsuji]

Yes, indeed the expression itself should work.

[DaGi07]

This is the UX config for this View. Column [Mese1] is the virtual column with the app formula, [Risorsa] is like “employer”

and this is the structure of DB

[Koichi_Tsuji]

I dont understand what you mean what you want to do.

[DaGi07]

If you read my second post probably you will understand. The problem is that the next view not respect the group if I use the formula SWITCH(MONTH([Periodo]),
1,“Gennaio”, 2,“Febbraio”,3,“Marzo”, 4,“Aprile”, 5,“Maggio”, 6,“Giugno”, 7,“Luglio”, 8,“Agosto”, 9,“Settembre”,10,“Ottobre”, 11,“Novembre”, 12,“Dicembre”, “”)
on the contrary It respects the group if I use the formula MONTH([Periodo]) but i’d see the month in the extended version like “January”

[SkrOYC]

DaGi07:

> > Schermata 2021-12-14 alle 15.32.071873×686 69.6 KB

It says that [Mese1] is type Number. Is that right? It should be the one with column type Text and the formula you posted above:

SWITCH(
  MONTH([Periodo]),
  1, "Gennaio",
  2, "Febbraio",
  3, "Marzo",
  4, "Aprile",
  5, "Maggio",
  6, "Giugno",
  7, "Luglio",
  8, "Agosto",
  9, "Settembre",
  10, "Ottobre",
  11, "Novembre",
  12, "Dicembre", 
  ""
)

[DaGi07]

Yes, I tried and If I turn number type in text type It lose the correct order of mounth but the group works correcly… maybe we are close to the solution…

[SkrOYC]

It should be Text, Number doesn’t makes sence.
You could add numbers.
Instead of ‘January’ → ‘1. January’