Filter date : 7 days ago

[FREEFITDAD]

Hello Community,
I a google sheet where every week i need to extract from it datas with specific conditions (TRUE in I column for example).
I want also to filter by date and only have row with a date that happened in the last 7 days in G column.

then i aggregate and send to chat gpt for analysis and resume send by email.

I tried a filter have this error message

Another solution would be to adapt the query directly in search row google sheets but i’m completly lost on that.

Sorry bother, totally new to automations.
Thank you in advance, best regards.

[samliew]

Welcome to the Make community!

{{ now }} is a variable of type DATE.

You cannot directly subtract 7 (a NUMBER) from a DATE.

You can use the built-in function addDays to add/subtract days from a date.

e.g.:

{{ addDays(now; -7) }}

For more information, see https://www.make.com/en/help/functions/date---time-functions

[FREEFITDAD]

You are amazing !!!
Thank you so much, take care

[samliew]

No problem, glad I could help!

Links

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate ← CHECK THIS OUT
• Make Blog – get the latest updates
• Features & Pricing

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make