Skip to main content
Nintex Community Menu Bar
Question

Date Range Filter on a Datetime Field in a Custom Object Writes Date Into SOQL

  • July 11, 2024
  • 2 replies
  • 3 views
  • Translate

Forum|alt.badge.img+5

On 11.0.2

Typically, when I create a date range filter on a date/time field on a standard object - it sets conditions with a datetime and works as expected.

I’ve run into an issue trying to do the exact same thing to a date/time field on a custom object - the model registeredlist soql shows that the filter has tried to set a date as the condition, which throws a soql error.

Can you confirm that this is a bug or an intended behavior?

Thanks.

Error:value of filter criterion for field 'CreatedDate' must be of type dateTime and should not be enclosed in quotes"

2 replies

Forum|alt.badge.img+5
  • Author
  • 32 replies
  • July 11, 2024

Sorry, to be more specific, this is happening in an aggregate model.

In the basic model, the date range filter does appropriately insert a datetime into the condition.

Translate

Forum|alt.badge.img+7

Hi David

Can you be more specific in how you intend using the aggregate model? i.e. What are you grouping or are you trying to aggregate a value according to a date range?

In the basic model if you expose the data in a table and then add the condition to the table then you need to choose the filter type as date range which will then automatically create the date range as CreatedDate >= & CreatedDate <= which will set the auto filter to autofilter_start_CreatedDate and autofilter_end_CreatedDate.


Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings