Airtable Module - Working with Dates

[TomH]

I have a column named ‘Date_Time’ in one of my tables and I’m trying to use the Airtable module ‘Search Records’. I only want records to be returned where the date on the record is the current month e.g. If I run the scenario on 31st Jan 2025, I only want to return records where Date_Time is within January 2025.

I have tried a number of different formulas with the help of multiple LLM’s but no success so far

[Msquare_Automation]

Hi @TomH

You can list all records and add a filter next to the search module:

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

[TomH]

Thank you! Such a simple fix, i really shouldn’t be doing this sort of stuff when I’m tired

[Msquare_Automation]

Glad to help you @TomH

Best regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation