I’m running a Make scenario that pulls data from a Notion database. One of the fields I’m using is a formula property in Notion called “Latest End Date”, which returns the latest of either an initial warranty date or any related service contract end dates (from a related database).
In Notion, the formula outputs a valid date—Notion even shows the result type as “date.” However, when I run the scenario in Make, some records pull that value in as a proper date, while others come in as an empty string or are treated as strings, even though all records clearly have a visible date value in Notion.
Because of this inconsistency, certain assets aren’t passing my date-based filters in Make.
I’ve verified:
- The formula is identical across all rows.
- The related data (warranty/service contract end dates) is populated.
- Notion shows the field as a valid date for all items.
- There are no null values/invalid dates being pulled for the affected data
Here’s an example of a successful run:
And a non-successful run:
The data passes the initial filter - Make recognizes the date, but looking at the bundle it’s treated as an empty string. Any ideas?