I see error when using datetime operator in google sheet

Questions
, ,
1

:bullseye: What is your goal?

I want to automate a daily check on my Google Sheet (a Time and Action / production calendar).

Every day, Make should scan the sheet, find all rows where the “stitching expected date” matches TODAY, gather those rows together, and send me a notification with the list of tasks due today.

:thinking: What is the problem & what have you tried?

The Problem:
When the scenario runs, Make fails to match the dates and returns 0 rows (0 bundles), even though there are rows in my Google Sheet with today’s date.

The issue seems to be a format mismatch:

My Google Sheet visually displays dates as DD/MM/YYYY (e.g., 28/07/2026).

However, Make reads the cell output as a text string (e.g., July 28, 2026 or a 5-digit number like 46230).

What I Have Tried So Far:

Native Module Filter: Used Date & time operators: Equal to mapped to now.

Text Filter: Used Text operators: Equal to with formatDate(now; “DD/MM/YYYY”).

Advanced GQL Query: Tried using select * where Z = date ‘YYYY-MM-DD’ in Search Rows (Advanced).

Route Filters: Moved the filter to the route line using parseDate() and formatDate() with timezone settings.

None of these setups are catching the rows consistently.

:clipboard: Error messages or input/output bundles

Input

Bundle 1Collection
Search Method drive
FilterArray
1Array
1Collection
a E
b formatDate(2026-07-28T16:44:03.293Z; “DD/MM/YYYY”)
o date:equal
Sheet Name Sheet1
Sort order asc
Spreadsheet Name 1teNnq7IWqneuQOgz35QgxgNbr-a5eDc0054zNKhw7IQ
Column range A1:CZ1
Table contains headers true
Value render option FORMATTED_VALUE
Date and time render option FORMATTED_STRING
Output
Bundle 1Collection
Total number of bundles 0

:link: Create public scenario page

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

TNA.blueprint.json (29.1 KB)

3

Hey there,

it looks like column E contains string type variables and not date type ones so using the text filter should have worked.

The issue is that in the blueprint you shared, you are not using the actual formatDate Make function. What you have is a text string. Select the function from the box under date and time functions.

4

I tried what u said but still the same result.

TNA.blueprint (1).json (28.7 KB)

5

You are formatting the date with double quotes around it and there is an empty space before the quotes, delete them and it should work.

6

still it didn’t worked. I tried all the feedback.

TNA.blueprint.json (29.1 KB)

7

Ok but its not a datetime operator its text string.