Help

SET_LOCALE and SET_TIMEZONE functions returns an incorrect hour

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
550 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Quero_Emigrar
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions
Quero_Emigrar
6 - Interface Innovator
6 - Interface Innovator

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 🙂

See Solution in Thread

2 Replies 2
CJSmith
7 - App Architect
7 - App Architect

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
6 - Interface Innovator
6 - Interface Innovator

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 🙂