Template doc: how to get the extended date in Italian

[Sandro_Ingrao]

I built a google doc template that works correctly, in which I report the formatted date in a column: TEXT ([DATA]; “MMMM”)

The month is written in English, how can I get the month written in Italian?

[Suvrutt_Gurjar · Accepted solution]

I think you may need to use a SWITCH() function based expression
Something like

SWITCH(TEXT([Data],“MMMMM”),
“January”, “gennaio”,
“February”, “febbraio”,
“March”, “marzo”,
“April”, “aprile”,
…,
-------,
“No Month”
)

Or simpler

SWITCH(MONTH([Data],
1, “gennaio”,
2, “febbraio”,
3 “marzo”,
4, “aprile”,
…,
-------,
“No Month”
)

help.appsheet.com

SWITCH()

Chose-one conditional evaluation

help.appsheet.com

MONTH()

Month of year from Date, DateTime, or Time