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.
Solved
SET_LOCALE and SET_TIMEZONE functions returns an incorrect hour
+7Best answer by Quero_Emigrar
Hi @Quero_Emigrar, check the format options on the formula fields and ensure the "Use the same timezone for all collaborators" is toggled off.
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 🙂
+12Hi @Quero_Emigrar, check the format options on the formula fields and ensure the "Use the same timezone for all collaborators" is toggled off.
+7Hi @Quero_Emigrar, check the format options on the formula fields and ensure the "Use the same timezone for all collaborators" is toggled off.
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 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.