You need to sign in to do that
Don't have an account?
lovetolearn
Save Error: unexpected token: ']'
Hi,
I keep getting this error: 'Save Error: unexpected token: ']'' for this SOQL statement:
SELECT ID FROM Account Where Account_Start_Date__c >: startDate AND Account_Start_Date__c <: endDate AND Account_Region_Text__c.contains(emplocation)];
Not sure where I went wrong wrong. Please help. Thank you.
Try :
Holiday_Region_Text__c LIKE : emplocation
All Answers
This is my complete code. I used another custom object instead of Account.
Try :
[SELECT ID FROM Holiday__c Where Holiday_Start_Date__c >: startDate AND Holiday_Start_Date__c <: endDate AND Holiday_Region_Text__c IN:emplocation]
I get this error: Save Error: IN operator must be used with an iterable expression
Try :
Holiday_Region_Text__c LIKE : emplocation
Thank you. That worked!!