How can I get =NOW() in the right timezone?

Hi all,

I want to use the =NOW() function to create a timestamp every time a form is submitted. But the timezone is UTC by default.

I’m located in Amsterdam so I would need UTC + 2 right now and UTC +1 in the winter.

1 Like

Hey @Jeroen_Ganseij :wave:t4: — thanks for reaching out. Here’s how you get the timestamps in your local timezone -

  • For UTC+2: =NOW()+(2/24)
  • For UTC+1: =NOW()+(1/24)

Note that you’d need to manually change it in the winter.

Hope these help.