Timezone Issue: Formula results with formatDate() display in UTC instead of local time (JST)

[kawano164]

Hello Everyone,

I am experiencing a timezone discrepancy between my Notion database and my NotionApps display.

The Problem
My Notion workspace is set to Japan Standard Time (JST / UTC+9). When I use a Formula property with the formatDate() function, the time is displayed correctly in JST within Notion itself. However, in NotionApps, the same formula result is displayed in UTC, which is 9 hours behind my local time.

Steps to Reproduce:

1. Set a Notion database’s timezone to JST (UTC+9).
2. Create a “Date” property and input a time (e.g., 17:00 JST).
3. Create a “Formula” property using: formatDate(prop(“Date”), “HH:mm”)
4. The formula result in Notion correctly shows “17:00”.
5. The same formula field in NotionApps shows “08:00”.

Expected Result:
The time displayed in NotionApps should match the local JST time shown in Notion (“17:00”).

Actual Result:
The time displayed in NotionApps is the UTC equivalent (“08:00”).

Workaround:
I have found a workaround by manually adding 9 hours in the formula using dateAdd(prop(“Date”), 9, “hours”). While this works, it would be more intuitive if NotionApps could handle the timezone conversion automatically.

Thank you for creating such a great tool.

[jatin_notionapps]

Welcome to the community @kawano164!

Unfortunately Notion does not provide us (third-party integrations) with information about the timezone in case of “Formula” properties. We do get the time zone information for “Date” properties.

Without the timezone information, we can’t really show you the correct time. So your workaround will be required until Notion provides us with the time zone information.