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.