Search query help

I’m using Integromat to search Airtable.

I’m trying to think through the logic of an Airtable search.

I have weekly podcast episodes that I produce across several podcasts. In Airtable I have all future episodes listed up through 11/11/2020 (67 days away and a Wednesday since I release on Wednesdays).

I want Integromat to search 56 days in advance of “today” (running the scenario on Wednesday’s). If there is a result of an already created record for that day, but not for the next week, I want it to give me those records so I can create new ones.

Does that make sense?

Doing some research it looks like I need an “AND” search:
AND( {Publish Date} = {{addDays(TODAY(); 56)}}, ???)

Thoughts?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.