# How to get all records from Google Sheet for Yesterday?

**URL:** https://community.make.com/t/how-to-get-all-records-from-google-sheet-for-yesterday/30843
**Category:** Questions
**Tags:** date-time-functions, google-sheets
**Created:** [March 18, 2024, 1:50pm UTC](https://community.make.com/t/how-to-get-all-records-from-google-sheet-for-yesterday/30843 "2024-03-18T13:50:56Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Oleksandr\_Tsap](https://avatars.discourse-cdn.com/v4/letter/o/8baadc/32.png) [@Oleksandr\_Tsap](https://community.make.com/u/Oleksandr_Tsap)
#### Post date: [March 18, 2024, 1:50pm UTC](https://community.make.com/t/how-to-get-all-records-from-google-sheet-for-yesterday/30843/1 "2024-03-18T13:50:56Z")

</div>

### 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?

---

<div class="post-metadata">

### Author: ![DanBorn](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/danborn/32/29159_2.png) [@DanBorn](https://community.make.com/u/DanBorn)
#### Post date: [March 18, 2024, 2:11pm UTC](https://community.make.com/t/how-to-get-all-records-from-google-sheet-for-yesterday/30843/2 "2024-03-18T14:11:56Z")

</div>

Hello! You can configure the Filter in the Search Rows module as follows:

 ![Screenshot 2024-03-18 at 3.10.12 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/e/1ec8fe7a19e9bc281c7d9d50a206b023491361d2.png)

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](https://www.make.com/en/help/functions/date---time-functions#adddays--date--number-).

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)}}`

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [April 1, 2024, 1:30pm UTC](https://community.make.com/t/how-to-get-all-records-from-google-sheet-for-yesterday/30843/3 "2024-04-01T13:30:19Z")

</div>