# Formula field: Incorrect time value (seems like in a different timezone) **URL:** \ **Category:** Bugs & Issues\ **Created:** [February 28, 2026, 2:11pm UTC](https://community.fibery.io/t/formula-field-incorrect-time-value-seems-like-in-a-different-timezone/10458 "2026-02-28T14:11:44Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [February 28, 2026, 2:11pm UTC](https://community.fibery.io/t/formula-field-incorrect-time-value-seems-like-in-a-different-timezone/10458/1 "2026-02-28T14:11:44Z")
Hi there! In my CRM I have 3 dbs: Activity, Contact, Contact Engagement In Contact Engagement I have a formula field “Last Activity” referencing the latest contact activity. However, in Contact Engagement db time is shown seems like in a different timezone - the UTC+0 one? ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/bab33147e0f9c80523815290fc8a64fcc9087c31.jpeg) ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/ea1a37bbb139180c49feece0a9b70225b490da4a.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/482e33f243767cce2ef88fa22af82d11f99c3edf.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [February 28, 2026, 2:46pm UTC](https://community.fibery.io/t/formula-field-incorrect-time-value-seems-like-in-a-different-timezone/10458/2 "2026-02-28T14:46:24Z")
> **[Timezones](https://the.fibery.io/@public/User_Guide/Guide/Timezones-41/anchor=Timezones-in-Formulas,-Automations,-Repo--7e9a6578-238b-41da-bc39-83ee68e65ac3)** ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [February 28, 2026, 4:31pm UTC](https://community.fibery.io/t/formula-field-incorrect-time-value-seems-like-in-a-different-timezone/10458/3 "2026-02-28T16:31:17Z")
Thanks for this. But it’s still not clear to me why it shows UTC as all I do in Last Activity formula field is referencing the existing field value (Last Activity DT) in the other db. What would be the elegant solution for my case without the need to “hard code” the time difference? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [February 28, 2026, 5:15pm UTC](https://community.fibery.io/t/formula-field-incorrect-time-value-seems-like-in-a-different-timezone/10458/4 "2026-02-28T17:15:06Z")
Conversion to text happens server side, so is in UTC ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [February 28, 2026, 5:17pm UTC](https://community.fibery.io/t/formula-field-incorrect-time-value-seems-like-in-a-different-timezone/10458/5 "2026-02-28T17:17:25Z")
I got this - it was in the Guide. What could be a client-side solution without the need for hard-coding the values? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [February 28, 2026, 7:25pm UTC](https://community.fibery.io/t/formula-field-incorrect-time-value-seems-like-in-a-different-timezone/10458/6 "2026-02-28T19:25:49Z")
There are no client-side formulas I’m afraid. We do plan to introduce a ‘workspace timezone’ so that server side calculations can be in the timezone of your choice. But if you have users across different timezones, they won’t all see the result adjusted to their zone - a text formula field value cannot vary from person to person. ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [February 28, 2026, 7:31pm UTC](https://community.fibery.io/t/formula-field-incorrect-time-value-seems-like-in-a-different-timezone/10458/7 "2026-02-28T19:31:07Z")
Yeah, the workspace timezone/locale would be awesome. I wonder how do they manage the distributed teams support in Notion and other apps when it comes to different timezones per user?..