Pretty much says it in the title. When I use the Now() function it’s off by exactly one hour. Is this because of Daylight Savings Time? Is there a way to get around this? [image]

[image] Closed - Timezone support: looking for beta testers You have been asking for it and we are on it! We are working on adding support for local timezones. As this spans all areas of the doc we want to make sure we are doing it right and need your help. Please reply …

Conor, is there anything unique about your setup? Are you outside of the US for example? Nigel.

Ah this is because all our time formulas currently return PST values. We have a work item to allow setting a time zone for a doc. Though that brings up another question - would it make sense to you that there would be a doc level timezone that would be the same for all users?

I think establishing a universal time zone across all docs makes a lot of sense. It eases the conversion process. Converting to the local time zone could be enabled either by an argument in Now() or maybe by a different function like NowLocal() Tangentially, I’m a really big fan of universal tim…

I have suggested a hack to some folks to create a named formula called NowLocal() and use it place of Now() - while we get it figured out.

I had this problem too, but it’s off by 9 hours since I’m in Sweden! Like @mallika suggests I created a variable: NowLocal() = Now() + Hours(9) I also needed to change the Today() so that it was correct: TodayLocal() = NowLocal().DateTimeTruncate("day")

Thanks for the good tip, but I don’t understand where to create this variable…where do I define variables in general? Sorry I am brand new to this…

Type the equal sign (=) anywhere on the writing surface or click the red plus icon in the top left corner to add a Formula.

Sorry, I still don’t understand. I can type a recognized formula with =, but I can’t define a new variable. If I type =Now() it tells me it is 3/19/2018 2:26:37 AM, but where I am it is 3/19/2018 3:56:37 PM Like you wrote above, I tried to create NowLocal and TodayLocal variables, but it is not r…

Hi Sonya, take a look at this - [image] You might be missing the Named Formula entry point.

Why is my time off by an hour with Now()?

Superhuman Ask the Community

mallika March 19, 2018, 4:10pm 11

Hi Sonya, take a look at this -

You might be missing the Named Formula entry point.

Date Modified Timezone / UTC

Topic		Replies	Views
[SOLVED]Now() returns a time zone 3 hours behind mine Ask the Community	2	882	July 3, 2018
Handling time-zone issues for non-listed timezones Tips and Hacks	1	819	September 26, 2019
Date Modified Timezone / UTC Ask the Community	4	1333	January 22, 2019
Show Last Modified, Created On and similar dates in the users timezone Product Feedback	7	2350	February 21, 2019
Now() value not precise when used through API Developers Central	8	286	October 28, 2025

Why is my time off by an hour with Now()?

Related topics