Date Filter for Google Sheets Search Issue!

[Matt_Price]

Hi All,

I am having the common problem of searching google sheets rows and filtering by a date, which is returning the wrong dates. There seems to be a difference between how Google Sheets & Make format or interpret a date depending if the day and month could be feasible either way (between 1-12). I have tried multiple ways and I have got to this stage.

This is my Jobs database:

This is my filter for Google Sheets Search Rows:

This is my output, which is missing J-1015 which should fall within the upcoming 5 days.

I would really appreciate some support on a fool-proof way to do this filtering because depending on the date, sometimes it works and sometimes it misses search results. The google sheets input is from a google form submission. Should I be adding an additional row when the form is submitted and formatting the date in a specific way and then filter that column?

Thanks in advance,

Matt

[Stoyan_Vatov]

Hey Matt,

Is the date column in the sheet coming in as a date variable or as a text string?

[Matt_Price]

Hey @Stoyan_Vatov,

The date in the google sheet is formatted how the google form responses table was setup, as a Date Time:

Then, the Google Sheets Search Rows module is setup as a Formatted String.

I need this as a formatted string because I’m using a text aggregator upstream to format and display information (please correct me if I am wrong here, but a serial number would prevent this?).

Thanks,

Matt