Skip to content
aeropage-round-dark
Aeropage Documentation
FAQ

icon picker
Incorrect airtable date


Why does aeropage show a different date than airtable?

When Aeropage retrieves a value from airtable, it also uses the local time zone when formatting the date. This is usually a desirable effect, but in some situations we want the date to remain unchanged (the same regardless of the user's time zone).

To fix this make sure to use “Use the same time zone for all collaborators
image.png

megaphone
Including the time zone requires adding the time “minutes:hours”, if you want to remove it, you need to create a formula.

Example of formula structure
DATETIME_FORMAT(
SET_TIMEZONE({Production Date}, "Europe/London"),
"D/M/YYYY"
)

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.