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”

⁠

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"

)

Why does aeropage show a different date than airtable?

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.