Local time using now() function

[qb15]

I’m using the now() function to set the default date in a date input to be today.

However, I’ve noticed that it is operating in a different timezone to me. It’s operating in USA time (I think PST), and not London time where I am.

Thus when I add an entry in morning it is using yesterday’s date.

Is there a way to have it set to Today’s date in the REAL user timezone?

[Darren_Murphy]

Here’s a couple of threads that you might find useful:

System/GMT Time - Solved!

This is an extension of the request for System Time, please. There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to…

Date Time UTC

For those who are interested in dates, here is a small script to return the date and time in UTC. You must complete the Data parameters with the “The date / time at form submission” option so that the date and time update every 10 seconds. [image] [image] [image]

[ThinhDinh]

What spreadsheet timezone are you using?