Problem with the regional settings of dates

TalkNet_TechnoS · 06-21-2019 03:11 PM

Where do I change the regional configuration?
According to the device the date I get MM / DD / YY or DD / MM / YY.
I thought I had solved it by inverting DD / MM and replacing MM with the name in Spanish of the month with the following expression:

INDEX (SPLIT (TEXT([Fecha Evento]),“/”), 2) & “ de ” &

SWITCH(INDEX (SPLIT (TEXT([Fecha Evento]),“/”), 1),1,“Enero”,2,“Febrero”,3,“Marzo”, 4,“Abril”,5,“Mayo”,6,“Junio”,7,“Julio”,8,“Agosto”,9,“Setiembre”,10,“Octubre”,11,“Noviembre”,12,“Diciembre”,"")& “ de ” &

INDEX (SPLIT (TEXT([Fecha Evento]),“/”), 3) &

" desde las "&

    LEFT((TIME([Hora Inicio])&""),5)&

" hs. hasta las "&

     LEFT((TIME([Hora Fin])&""),5)&" hs. "

But they just reported an error in another device in which the day and month are reversed as seen in the images:

Aleksi

To be sure for the date in a text, you should use expressions DATE and MONTH instead of INDEX(SPLIT(…)). In generally you should set both spreadhsheet and app locale settings (table) as Spanish.