Using toText(Date) and Date has a time. e.g. 15:00 oclock set. But it displays 14:00 oclock after toText(). Maybe wrong timezone?

Hi! Yes, our bug. We don’t support timezones in formulas, sorry for that :frowning: Will fix that! :muscle:

I believe Fibery uses UTC under the hood for all such calculations (probably because this is how JS normally does things and the clojurescript library they use wraps this? not 100% sure). I’m guessing you’re in UTC+1. In my own formulas, I often want the Date of a given time, so use Time.start - Ho…

Yes, the idea with shifting the hour is an idea. But you are right with the daytime problem twice a year. Just wait for the fix. Maybe an own function dateToText(date,format,zone) is also an idea.

Yeah, timezones are generally a huge pain to deal with. Handling it by using simple hour offsets is setting yourself up for failure. Like you said, if we could have whatever library that Fibery uses be exposed as a dateToText(...) and textToDate(...) formula that would be truly awesome.

Probably/possibly related to this issue which is dates only [image] [FIXED] Converting an End date to text Bugs & Issues If I create a Date field with Start and End dates, when I use the ToText function on the End date: ToText(Date.End) I don’t get what I expect, but the…

FYI: Timezones See how timezones [do not] work in Fibery and how to handle it in Formulas, Automations, Reports and etc.

Workarounds for timezones should be a short term and not a long term solution. It’s not reasonable to pitch Fibery as a remote work “second brain for teams” if my whole team needs to be in the same timezone.

Here’s a thought experiment, and I’m curious to hear what people think. Given that it is ideal if multiple people from different time zones can work in Fibery simultaneously, even editing the same entity simultaneously, how should a text field that contains a date-to-text conversion be shown to the…

What I don’t get is why reinvent the wheel? I’m sure there will be extra effort to reengineer some internals, but there’s plenty of libraries that have figured out how to handle nearly all the edge cases for working with date, time, datetime, and timezones. For example: https://momentjs.com/ and Da…

Since I’m not a sw guy with experience of these libraries, can you tell me, for something like dateToText(someDatetime, tz) is it correct that the every user would see the same thing (so it will be ‘correct’ only for the chosen timezone)? And does the result change as the clocks go back/forward in…

toText(Date) wrong timezone?

Bugs & Issues

Chr1sG May 21, 2021, 6:08am 6

Probably/possibly related to this issue which is dates only

Topic		Replies	Views
Allow specifying TimeZone with ToText([Date]) Ideas & Features dates	12	568	January 20, 2023
Different timezone for date type field Bugs & Issues	2	242	August 24, 2023
Formatting UTC Date Ideas & Features formulas , dates	13	469	December 5, 2023
Option to filter on "time" from entity's datetime in month view Ideas & Features	13	398	October 2, 2023
Twitter post about potentially new Fibery settings	9	419	January 23, 2024

toText(Date) wrong timezone?

Related topics