DATETIME_FORMAT how to set SET_TIMEZONE + SET_LOCA...

[Quero_Emigrar]

I just found out that both SET_LOCALE and SET_TIMEZONE functions returns an incorrect hour, at least for Europe/Lisbon and en-gb as per the below examples:
SET_TIMEZONE(NOW(), 'Europe/Lisbon')
SET_LOCALE(NOW(), 'en-gb')

Both these functions as returning 1 hour less than the correct one.

[CJSmith]

Hi @Quero_Emigrar, check the format options on the formula fields and ensure the "Use the same timezone for all collaborators" is toggled off.

[Quero_Emigrar · Accepted solution]

Thanks CJ

In fact it was the opposite: I needed to toggle it on and select the timezone Europe/Lisbon for the time to be correct. I had totally forgotten this option.

Thanks again CJ 🙂