Skip to main content
Nintex Community Menu Bar
Question

Model Date Condition with a Specific Date value returns no data

  • Jul 10, 2024 4:18 PM UTC
  • 3 replies
  • 36 views
  • Translate All

Forum|alt.badge.img+10

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.

3 replies

Forum|alt.badge.img+18

Is the Actual_Create_Date__c a Date or Datetime field?

Translate

Forum|alt.badge.img+10
  • Author
  • Jul 10, 2024 5:29 PM UTC

It is a Date formula field.

Translate

Forum|alt.badge.img+10
  • Author
  • Jul 10, 2024 5:29 PM UTC

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.

Translate