Hi!
I want to return today’s date (2023-12-19) from Airtable:
Here’s the module I’m using:
It should return two bundles for 2023-12-19, but I get zero:
Can anyone help? Thanks!
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.
2 Likes
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
3 Likes
Here’s what it looks like:
Weirdly, Bundle 1 doesn’t look anything like the others. It doesn’t show the LI Publish Date at all.
Apologies
Please try with formula, refer image for guidance.
2 Likes
Thanks, I’ll get an error:
But the error goes away when I remove the green dashes:
Here’s the result:
To troubleshoot, I changed “=” to “>=” and it works:
…
But when I remove the “>” it returns nothing.
…
Here’s the Airtable:
Do you have any suggestions?
Figured it out. You need to add a column to convert the date into a string.
And use that date string in Make:
…
6 Likes
Hey there @MakeItTillYouMakeIt 
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 your journey to find the final solution. We appreciate you keeping us posted during the process.
Keep up the amazing job! 
1 Like