Notion Formula Returns Empty Date After Time Zone Change: Fix

If you changed your Notion workspace time zone and a formula that previously displayed a date now shows a blank cell, the issue is likely a mismatch between the time zone offset and how Notion stores date values internally. Notion uses Coordinated Universal Time (UTC) for all date and timestamp data, and formulas that rely on functions like now() or dateAdd() can break when the workspace time zone is altered without adjusting the formula logic. This article explains why the empty date occurs and provides three concrete fixes to restore your formula output.

Why a Time Zone Change Makes a Notion Formula Return Empty

Notion stores all date and timestamp data in Coordinated Universal Time (UTC). When you create a formula that uses functions like now(), dateAdd(), or timestamp(), the formula calculates against UTC. The workspace time zone setting is a display-only preference — it tells Notion how to show dates and times in the interface, but it does not change the underlying UTC values.

When you change the workspace time zone, a formula that previously returned a valid date can become empty because the formula logic no longer matches the offset. For example, a formula that subtracts a fixed number of hours from now() may produce a date that falls on the previous day in UTC, causing the formula to return an empty string if you use formatDate() without specifying the time zone. The root cause is that the formula does not account for the new offset, so the result is either an invalid date or a null value that Notion chooses to display as blank.

Another common scenario is a formula that compares two dates — one from a date property and one from now(). After a time zone change, the comparison may fail because the offset difference creates a date mismatch, and the formula returns nothing. The same problem occurs when using dateAdd() or dateSubtract() with a time interval that expects a specific time zone context.

How to Identify the Affected Formula

Before applying a fix, determine which formula is returning empty. Open the database where the formula property exists and hover over the formula cell. If the cell is blank, click the formula property name to open the formula editor. If the editor shows a formula that uses now(), dateAdd(), dateSubtract(), or formatDate() without an explicit time zone parameter, that formula is likely affected. Write down the current expression so you can compare it after the fix.

Steps to Fix an Empty Date Formula After a Time Zone Change

The fix depends on the function your formula uses. Below are the three most common patterns and their corrections.

Fix 1: Add an Explicit Time Zone to formatDate()

If your formula uses formatDate() to display a date or time, the function may return an empty string when the input date is invalid or when the format string does not match the time zone. Add the time zone as the third argument.

1. Open the formula editor
   Click the formula property header in the database. Then click Edit formula or double-click the property name.
2. Locate the formatDate() call
   Find the line that reads something like formatDate(prop("Date"), "MMM DD, YYYY"). Note that it has only two arguments.
3. Add the time zone parameter
   Change the formula to formatDate(prop("Date"), "MMM DD, YYYY", "America/New_York"). Replace "America/New_York" with your current workspace time zone. Use the IANA time zone name such as "America/Chicago", "America/Los_Angeles", or "Europe/London".
4. Save the formula
   Click Save or press Ctrl+Enter on Windows or Cmd+Enter on Mac. The empty cell should now display the correct date.

Fix 2: Convert now() to the Target Time Zone Before Arithmetic

If your formula uses now() with dateAdd() or dateSubtract(), wrap now() with fromTimezone() to convert the UTC timestamp to the desired time zone before performing the calculation.

1. Open the formula editor
   Click the formula property header and select Edit formula.
2. Wrap now() with fromTimezone()
   Change now() to fromTimezone(now(), "America/New_York"). Use your workspace time zone.
3. Update the arithmetic function
   If you have dateAdd(now(), 7, "days"), rewrite it as dateAdd(fromTimezone(now(), "America/New_York"), 7, "days"). This ensures the base date is in the correct time zone.
4. Save the formula
   Press Ctrl+Enter or Cmd+Enter. The formula should now return a valid date.

Fix 3: Use toTimezone() When Comparing Two Dates

If your formula compares a date property against now() and returns empty after the time zone change, convert both dates to the same time zone using toTimezone().

1. Open the formula editor
   Click the formula property header and select Edit formula.
2. Convert the date property
   Change prop("Start Date") to toTimezone(prop("Start Date"), "America/New_York").
3. Convert now() to the same time zone
   Change now() to toTimezone(now(), "America/New_York").
4. Save the formula
   Press Ctrl+Enter or Cmd+Enter. The comparison should now work and return the expected date.

If Notion Still Shows Empty Dates After the Fix

Formula Returns Empty When the Date Property Itself Is Empty

If the formula references a date property that has no value, the formula will always return empty regardless of the time zone. Check that the source date property actually contains a date. If the source is empty, fill in the date or modify the formula to handle null values with if(empty(prop("Date")), "No date", formatDate(...)).

Time Zone Name Is Incorrect or Misspelled

Notion uses IANA time zone names. A misspelled name like "America/NewYork" instead of "America/New_York" will cause the formula to return empty. Verify the exact name by going to Settings & Members > Settings > Time zone and copying the displayed time zone string. Use that exact value in your formula.

Formula Uses timestamp() Without a Time Zone

If your formula uses the timestamp() function to convert a date to a Unix timestamp, the result is always in UTC. After a time zone change, you may need to adjust the timestamp by adding or subtracting the offset. Use fromTimestamp() with toTimezone() to convert back to the desired time zone. For example: toTimezone(fromTimestamp(prop("Unix Timestamp")), "America/New_York").

Notion Formula Functions for Time Zone Handling: Comparison

Function	Purpose	Syntax Example
formatDate() with time zone	Displays a date in a specific time zone	formatDate(now(), "MMM DD", "America/New_York")
fromTimezone()	Converts a UTC date to the specified time zone	fromTimezone(now(), "Europe/London")
toTimezone()	Converts a date from any time zone to another	toTimezone(prop("Date"), "Asia/Tokyo")

After applying one of the fixes above, your formula should display the correct date again. If the problem persists, check the formula for other functions that might depend on the workspace time zone, such as dateBetween() or minute(). You can also test the fix by temporarily reverting the workspace time zone to the previous value — if the date reappears, the formula still lacks an explicit time zone reference. For advanced users, consider creating a helper formula property that stores the converted date, then reference that property in all other formulas to avoid repeating the time zone conversion.