Model Date Condition with a Specific Date value returns no data

When creating a Date condition on an aggregate model…

  • with a specific date entered no data is returned.

  • with a value of “Yesterday”, data is returned.

Is the Actual_Create_Date__c a Date or Datetime field?

It is a Date formula field.

I figured out the problem. The Actual_Create_Date__c is a formula field pulling the value of the created date which is a Date Time field. I had to fix the formula to be DATEVALUE(CreatedDate) because the time was still being added.