Model Date Condition with a Specific Date value returns no data

  • 1
  • Problem
  • Updated 2 years ago
  • Solved
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. 

Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Is the Actual_Create_Date__c a Date or Datetime field?
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
It is a Date formula field.
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
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.