Help

Time Not Changing On Formula Field

Topic Labels: Dates & Timezones
869 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Shaun_Hughston
6 - Interface Innovator
6 - Interface Innovator

I have a formula field as follows:

DATETIME_FORMAT(SET_TIMEZONE(NOW(), ‘Australia/Sydney’), ‘HH:mm’)

However, the field seems to remain static - the time never actually changes 😕

Can anyone spot an error in the formula, or is there a better way to do it?

The goal is just to show the current time in a given timezone. Just the time, not the date.

1 Reply 1