Whenever you need to set a timezone, you'll need to use this function in combination with DATETIME_FORMAT().
#PLANNER PLUS TIME ZONE FULL#
This is written in the form SET_TIMEZONE(datetime, 'timezone identifier'), in which the format specifier can be something like 'America/Chicago', 'Europe/Oslo', or 'Pacific/Marquesas'.įor a full list of supported timezone identifiers, see this article. This article will cover its use and is part of a guided course which you can view here. The SET_TIMEZONE()function will allow you to set the timezone for the data from a date type field. Setting a timezone with a SET_TIMEZONE() formula function You will then be able to choose your desired timezone from a drop-down list. You can choose a specific timezone for a date field by toggling the option to "Use the same time zone for all collaborators" in the field configuration menu. Setting a timezone in the date field configuration menu For more complex cases where you might want to conditionally show different timezones, we recommend the formula option. Using the toggle is the easiest option and works well for cases where you want the specified timezone to be used 100% of the time. There are two ways to manually set a timezone for a date field: using the "Use same timezone for all collaborators" toggle in the field configuration menu and selecting the desired timezone OR using a formula field with the SET_TIMEZONE() function. What this means is that collaborators working together in the same base can, and will, see different dates and times unless a specific timezone has been specified (again, on a field-by-field basis).
But, how you choose for them to display in your base is a field-level setting that will affect all collaborators. Options for displaying datesĪll dates are stored in Airtable in Greenwich Mean Time, or GMT.
#PLANNER PLUS TIME ZONE HOW TO#
This article will cover how to work with and troubleshoot timezones, and is part of a guided course which you can view here.
0 kommentar(er)
