I have a date format like this “2024-01-30 03:47:43”. The cell has a date format. For getting data from Google Sheets I’m using the Search Rows module.
Can I set the filter inside a module and how it should look like?
Hello! You can configure the Filter in the Search Rows module as follows:
The addDays(now;-1) creates yesterday’s date and then we’re just modifying the hours to midnight and just before midnight. You can read more about Make’s date & time functions here.
Let me know if you need any further help 
Here’s a snippet for you to copy & paste so that you don’t have to rewrite it 
{{setSecond(setMinute(setHour(addDays(now; -1); 0); 0); 0)}}
4 Likes