This message was deleted.
# questions
b
This message was deleted.
🤦 1
f
Hi Mike, Dates are formatted according to the user’s locale (via browser settings).
a
@freezing-car-89097 how do we turn that off? I just need the time to display the same regardless of timezone. In Airtable the setting is “Use GMT” time
t
Same question here, this seems like a serious limitation if we can't force a certain timezone.
a
@dazzling-terabyte-63131 in case you’re on while Thu is off
d
Dates are formatted according to the user’s locale (via browser settings). This is automatic, and we don’t support copying the Airtable formatting settings yet. Unfortunately, there is not a way to force this in Stacker. Rather, I'd recommend taking a look at the time zone settings for your browser.
a
Hmm is there a ticket/request open for this? It’s odd behavior to not just display the time that is listed in Airtable, and it really throughts things off like formulas. See here:
thats referencing the same data, but Stacker converts one of the fields, but not hte other
d
Airtable's time field can render unexpected results based on the field type. But, you can vote for this feature on our features request board. https://stacker.canny.io/feature-requests/p/add-formatting-options-for-date-fields In your example, what type are the fields shown in the screenshot? And which one is showing how you'd like?
a
@dazzling-terabyte-63131 - Posting a longer explanation in #C026T10EBFZ, but “event_announce_date” is set to 10AM GMT in Airtable, the “formula_event_announce_date_pretty” is a formula referencing that (so displaying as a string)
you’d expect those to match, but they don’t because Stacker is converting the date-time field (“event_announce_date”) to local time unexpectedly