This may just be a UK specific question. Does anyone know why hour(no

But even checking that box will still return the GMT value from now(), it will just be displayed differently. Using local() adds an offset to change the actual datetime value rather than just it's display. If you run local(now()) then it actually looks wrong because the datetime is returned in your time zone and then Appian tries to display it in your time zone again. But the underlying value is what you need to use in order to perform operations on it such as hour()

But even checking that box will still return the GMT value from now(), it will just be displayed differently. Using local() adds an offset to change the actual datetime value rather than just it's display. If you run local(now()) then it actually looks wrong because the datetime is returned in your time zone and then Appian tries to display it in your time zone again. But the underlying value is what you need to use in order to perform operations on it such as hour()