Schedule Email filter condition help

[Tony_Landowski]

I have created a scheduled event to send an email when a column date field [Contract Ends Date] is equal to today.  But in my testing I am getting every line of data from the sheet.  Can someone help me.  What have I missed.

[Contract Ends Date]=Today()

[SkrOYC · Accepted solution]

Change it to:

AND(
  ISNOTBLANK([DATE]),
  [DATE]=TODAY()
)