function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rohith Kumar 98Rohith Kumar 98 

Why do I get error executing this SOQL query?

ERROR: [object Object]: The requested operation is not yet supported by this sObject storage type, contact salesforce.com support for more information.

Query: SELECT Id, DEAL_NUM__c,  Vehicle_Status__c, MDF_DATE__c, Status_Updated_Date__c from VEHICLE_SALE__x  WHERE DAY_ONLY(MDF_DATE__c) >= 2021-12-09

NOTE: MDF_DATE__c is DateTime field type.
Best Answer chosen by Rohith Kumar 98
mukesh guptamukesh gupta
HI Rohit,

DAY_ONLY method does not support in Exernal Object SOQL,
  
SELECT Id, DEAL_NUM__c,  Vehicle_Status__c, MDF_DATE__c, Status_Updated_Date__c from VEHICLE_SALE__x  WHERE MDF_DATE__c >= 2021-12-09

if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh

All Answers

AnkaiahAnkaiah (Salesforce Developers) 
Hi Rohith,

Please try with below query. 
SELECT Id, DEAL_NUM__c,  Vehicle_Status__c, MDF_DATE__c, Status_Updated_Date__c from VEHICLE_SALE__c  WHERE DAY_ONLY(MDF_DATE__c) >= 2021-12-09

If this helps, please mark it as best answer.

Regards,
Ankaiah Bandi

 
mukesh guptamukesh gupta
HI Rohit,

DAY_ONLY method does not support in Exernal Object SOQL,
  
SELECT Id, DEAL_NUM__c,  Vehicle_Status__c, MDF_DATE__c, Status_Updated_Date__c from VEHICLE_SALE__x  WHERE MDF_DATE__c >= 2021-12-09

if you need any assistanse, Please let me know!!

Kindly mark my solution as the best answer if it helps you.

Thanks
Mukesh
This was selected as the best answer
voltan maryavoltan marya
Chili’s Menu Price List India 2021