Why doesn't Now().toSeconds() give the correct epoch time?

[Connor_McCormick1]

@Paul_Danyliuk @Federico.Stefanato @Johg_Ananda @Ryan_Martens2

Any idea why Now().ToSeconds().EpochToDate() doesn’t return today’s date?

was playing with @Ben_Lieber1 | @Ben_Lieber 's doc Epoch Time Converter

[Paul_Danyliuk]

Because Coda calculates time not based on 1/1/1970 but on 1/1/1900, which mimics how Excel used to do it since forever.

That’s why what you get from Now().ToSeconds() is not an Unix epoch but 70 years’ worth more of seconds. To adjust, subtract Date(1970, 1, 1).ToSeconds() from it.

BTW the 1900 date system is the reason why bugs like this exist:

So, why would Totext() return a quarter before real value, when apply to Time field?

No much more to tell. You write down your flamant 11:00 meeting in a Time field. When you show it with your field.Totext(), it reads 9:45. Hurray! never late again PS: I am GMT+2, don’t think related Edit 1: after @joost_mineur help, i have realized it has nothing to do with Totext, but somehow value shown through formulas differ a quarter from the value I entered, or that it’s shown in table cells. Edit 2: An image worths more than thousand words [Paranormal time]