How to change DateFormat when using Text([Date],"ddd, dd.mmm.yyyy")

[HoaHi]

Hi All,

I have a problem after creating a pdf file with Date. In the template, i using TEXT([Date],"ddd, dd.mmm.yyyy") and i want the result will be in English format like: Mon, 04.Jul.2022. But it display in my language: T2, 04.Thg4.2022. I try change the setting on appsheet, GGS, Drive and GGDocs but it 's impossible. Can anyone help me?

[1minManager]

So this might help.  Something I've just done on a email template file:

CONCATENATE(

"...has been changed to ",

[Booked Time],

" on ",

INDEX(LIST("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"),WEEKDAY([Booked Date])),

" ",

TEXT([Booked Date],"dd/mm/yyyy")

)

Considered using something like this to make the text string exactly what you need

Simon@1minManager.com

[HoaHi]

Thanks for your answer. But it's quite complex for formulas in template . I found out the solution for this problem. I have to change language setting in my browser to display expected date formatting.

[Quatz]

Solve my problem but creates a new one... It take out of cronology the related data. 

My template:

Andamentos deste atendimento:

<<Start: [Related Andamento Atendimentos]>>

<<TEXT([Data],"dd/mm/yyyy")>>

<<[Observações]>>

<<End>>

[Quatz]

Solved by using ORDERBY([Related Andamento Atendimentos], [Data], FALSE)