Change your time zone in Base

Change your time zone in Base

2 min read
I. Intro
Time zones often pose an obstacle when collaborating internationally. Now you can use Base time zone settings to unify all times displayed in a table, avoiding problems and misunderstandings caused by time differences and making collaboration smoother.
Common scenarios:
  • International project management: Timestamps are an important link in project management. Unifying key display times can ensure a project progresses smoothly.
  • Cross-border e-commerce management: Purchase times, ordering times, and other times can be unified to a single display time for easier order management.
II. Steps
Basic Info
The default time zone for a base will match the time zone of the owner who created the Base. For example, when the owner is located in the UTC+08:00 time zone, all of the times on the Base created by them will also be in the UTC+08:00 time zone.
Set the time zone
  • Click the ... icon in the upper-right corner of Base to access More > Document time zone.
250px|700px|reset
  • Select your desired time zone in the pop-up window and click Confirm to update all time zones in your base.
Note: If you later need to modify the time zone, follow the same steps to select a new time zone.
250px|700px|reset
Displaying dates and times
There are two main methods of displaying dates and times in Base.
  1. Display date only
If only a date was displayed originally, changing the time zone will mean that people in different time zones will all see the same date. For example, 2022/12/31 in UTC+08:00 will be shown in the base as 2022/12/31 regardless of the time zone used by viewers.
250px|700px|reset
  1. Precise timestamps
If the original time displayed included hours and minutes, changing the time zone will mean that people in different time zones will be able to see the GMT time zone too. For example, 2022/12/31 15:30 in UTC+08:00 will be shown in the base as 2022/12/31 15:30 (GMT+8) regardless of the time zone used by viewers.
250px|700px|reset
III. FAQs
Will changing the time zone automatically update the existing timestamps?
Yes, all timestamps in a base will be automatically updated to the same time zone.
Does updating the time zone mean that everybody sees the same times?
Yes.
Which Base functions are affected when I change the time zone?
Function
Scope of impact
Automated workflow
Any automated workflow involving dates and times.
Dashboard
Any charts involving dates and times.
Formulas
Any formulas involving dates and times.
Group, Filter, Sort, Lookup
Any grouping, filtering, sorting, or lookup functions involving dates and times.
Automatic Calculations
Any calculations involving earliest and latest times or time ranges.
Field type
Any fields involving date, time created, time last updated; any formula or lookup fields involving dates and times.
Copy and Paste
External dates pasted into a base will be automatically displayed based on the base time zone.
For example, 2022/12/31 15:30 → 2022/12/31 15:30 (GMT+8)
Make a copy
Remains the same as the original document.
When using Base across time zones, the preview of time calculations and format conversion functions are inconsistent with the actual results. What can I do?
When Base is used across time zones, the preview of time calculations and conversion functions may be inconsistent with the actual calculation results. For example, when using the TEXT function to convert a date value to a day of the week, the preview and the actual result may differ by one day due to the time difference. In this case, you can create a new copy and change the time zone to the local time zone. In the copy, the preview and the actual results of date-related calculations should be the same.
Written by: Lark Help Center
Updated on 2025-01-28
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom