How to compare a date to current date

Hi everyone,
I am pulling database items from Notion and one property is “Publish Date” which contains the date a post is supposed to be posted.
I want to load posts into a Data Store if the Publish Date = Today.
I tried to create a filter with the expression:
formatDate(notion_field; MM-DD) Equal to formatDate(now; MM-DD) but it didn’t work.
What is the correct way to check if a date occurs today?
Thanks kindly!

1 Like

If you are using formatDate just use string/text comparison instead of datetime for equals.


Thanks, that worked great. Is it possible to do the comparison without using formatDate()?

1 Like