How to compare a date to current date

Questions & Answers
,
1

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!

compare-stored-date-to-system-date
compare-stored-date-to-system-date1127×825 61.8 KB

1 Like
2

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

1 Like
3

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