Skip to main content

I'm trying to create a DLRS for Account (Parent) and Event (Child). My relationship criteria concerning the Event object is intended to focus on 1 specific record type and only for those Events that were logged after the 1st October 2022.

 

Currently I put down: RecordTypeId = '0124J000000xlmuQAA' AND ActivityDate > 2022-10-01T00:00:00Z

 

However I'm receiving an error stating this: Relationship Criteria: Relationship Criteria 'RecordTypeId = '0124J000000xlmuQAA' AND ActivityDate > 2022-10-10T00:00:00Z' is not valid, see SOQL documentation http://www.salesforce.com/us/developer/docs/soql_sosl/Content/sforce_api_calls_soql_select_conditionexpression.htm, error is 'value of filter criterion for field 'ActivityDate' must be of type date and should not be enclosed in quotes'

 

Any ideas on how to resolve this as I'm unsure.

 

Cheers,

Saf

#Declarative Lookup Rollup Summaries #DLRS SOQL #SOQL Queries

5 respostas
  1. Steven Trumble (Strum Consulting) Forum Ambassador
    7 de mar. de 2023, 11:48
    'RecordTypeId = '0124J000000xlmuQAA' AND ActivityDate > 2022-10-10
0/9000