Unless I am mistaken, the following should give a result of 1:
As far as I can see, all calculations result in a value that is 3600 lower than it should.
Similar to the above, EpochToDate seems to not be correct:
As far as I can see, all calculations result in a value that is 3600 lower than it should.
What’s the doc time zone? Epoch is 1970-1-1 00:00:00 UTC — always UTC. It’s a coordinated timestamp whose purpose is to identify a moment in time on Earth regardless of where you are.
If you’re on the Europe/Amsterdam timezone, your 00:00:00 is actually 23 PM UTC (hence -3600 seconds) and 00:00:00 UTC is your 1 AM.
3 Likes
Hello @Paul_Danyliuk ,
Thank you for clarifying that - I had thought it would count from 1/1/1970 0:00 in your own timezone, but UTC explains it all. Good to keep that in mind when using this formula, it is easy to adjust the outcome using CurrentTimezone (if necessary).
With your explanation I can only conclude the formula works as exepcted.
Greetings,
Joost
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.