Filter where {date) is equal 2 days from today

Lookup dates can be tricky to handle. The lookup value will be an array. However, since you don’t need to get the actual date, you might not have to deal with that array.

You could create a view that does the filtering for you, and then get the records from the view.

Or you could use filterByFormula in your API call. The filter that you pass should be identical to a formula that you could enter in the user interface. You will need to url encode it as part of your query url parameters. The API documentation has the details.

DATETIME_DIFF(date, TODAY(), 'days') = 2

On the other hand, these formulas will always return dates that are two day in the future. If you want to send an email two days after the date, you should be looking for dates that were two days ago . In that case, just adjust the filter to “days ago” or the formula to -2.

If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details and a screen capture?

Thank you for explaining that you are using Integromat. I thought you were using the Standard REST API because this is posted in the API section of the forums.

If you want Integromat to process records 2 days after the “Check-out” date, and “Check-out” is a date field in your table, you need to have Integromat look for “Check-out” dates that occured 2 days before the current date.

Your Integromat formula to add days is adding 2 days to “now”, which will result in a date that is two days after today. For example, today is June 2. The addDays(now;2) function will add two days to June 2, and come up with June 4. However, you really want to process a record that was check out two days ago on May 31. To fix this, try subtracting 2 days. (You may need to add a negative 2 instead of subtracting.)

You may also have some difficulty with comparing dates because the you are testing the “Check-out” value (which is probably a date/time object with a time) against a text string that has no time.

I suggest you calculate the difference between the two dates (“check-out” and now) and see if the difference is what you want. Here is the documentation for Integromat’s date/time functions.