Hi! I want to return today’s date (2023-12-19) from Airtable: [image] Here’s the module I’m using: [image] It should return two bundles for 2023-12-19, but I get zero: [image] Can anyone help? Thanks!

Figured it out. You need to add a column to convert the date into a string. [image] And use that date string in Make: [image] …

What dooes the “LI Publish Date” look like in Make when you delete the Formula and return all Output Fields? It’s a Date type field, and filtering using string equality operators may not work since it’s a Date field.

Hi @MakeItTillYouMakeIt Please try the formula using a single quotation mark: {L1 Publish Date} = ‘{{formatDate(now; “YYYY-MM-DD”)}}’ If you require additional assistance, please don’t hesitate to reach out to us. MSquare Support Visit us here Youtube Channel

Here’s what it looks like: [image] Weirdly, Bundle 1 doesn’t look anything like the others. It doesn’t show the LI Publish Date at all.

[image] Msquare_Automation: {L1 Publish Date} = ‘{{formatDate(now; “YYYY-MM-DD”)}}’ I tried this: [image] And it gave me an error: [image]

Apologies Please try with formula, refer image for guidance. [image]

Thanks, I’ll get an error: [image] [image] But the error goes away when I remove the green dashes: [image] Here’s the result: [image]

To troubleshoot, I changed “=” to “>=” and it works: [image] … But when I remove the “>” it returns nothing. [image] … Here’s the Airtable: [image] Do you have any suggestions?

Hey there @MakeItTillYouMakeIt :wave: Just wanted to step in and applaud you for the outstanding job you did while figuring out this struggle of yours. It is so heartwarming and motivating to see Makers getting more advanced and proficient with our tool. Also thank you very much for guiding us on …

Search Airtable: How to get records with today's date?

Questions

Topic		Replies	Views
Create a Filter-Formula for Airtable Dates Questions date-time-functions	3	504	June 26, 2024
How to create a date condition in Airtable module Questions filters , airtable , format-date	4	71	June 2, 2025
Airtable Search Records Formula does not Output Bundle Questions date-time-functions , airtable	4	416	May 22, 2024
Trying to search All Airtable Records by date -1 Questions airtable	2	83	December 16, 2024
How to compare dates within a formula on requesting airtable results? Questions airtable , api , format-date	2	145	February 26, 2025

Search Airtable: How to get records with today's date?

Related topics