Jul 13, 2023 02:38 AM
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! Go to Solution.
Jul 13, 2023 10:55 AM - edited Jul 15, 2023 04:30 AM
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 🙂
Jul 13, 2023 10:26 AM
Hi @Quero_Emigrar, check the format options on the formula fields and ensure the "Use the same timezone for all collaborators" is toggled off.
Jul 13, 2023 10:55 AM - edited Jul 15, 2023 04:30 AM
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 🙂