Skip to main content

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.


Reply