I’m having a one module simple scenario that I can’t get to work properly.
The goal is to search Google Sheets and return all the rows with a date before today.
In Make:
I’ve set up the Search Rows module to return rows based on a filter with a “Datetime Operator” that looks at “Earlier than”, and {{formatDate(now; “DD/MM/YYYY”)}}
In Sheets:
I’ve formatted the appropriate column as date, in the same way: DD/MM/YYYY.
The result is a bit random.
The first 8 bundles are correct, but the following 8 bundles are rows of which the date is AFTER today.
Can anybody make sense of this and help me?
Thanks!
You shouldn’t need to formatDate.
Just put the special {{now}} variable in the lower half of the filter with nothing else.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Using the {{now}} variable didn’t make a difference, I got the same (wrong) results.
What did make a difference was going to the Search Rows’ Advanced Settings and selecting the following:
Value render option → Unformatted value
Date and time render option → Serial number
Now the output is correct. It’s a bit weird because the output is a serial number, but it works.
I assume there is some kind of mismatch between the Make and the Sheets formatting, even though they were configured in the same DD/MM/YYYY format.
3 Likes
