Thanks for your question!
To use the filterByFormula parameter, you’ll want to write an Airtable formula that will return true for the records that you want to select. We have to check two things in our formula:
- that the date is before today
- that the date is 5 days ago or later (i.e., the date is after the day that was 6 days ago)
We can write the following Airtable formula to check both of those conditions:
To get this formula to work, you’ll first need to convert your date field to the Date field type, since it appears to be a text field currently. Once you do that, you can use the formula functions that treat it as a date.
For more on Airtable formulas, see this reference guide.
I hope this helps! Feel free to follow up if you’re still running into issues.