we have a financial analyst using the ODBC for Salesforce to retrieve information from our Salesforce Implementation....on our Query we are getting the MS Query error 'numeric value out of range'. I have isolated it to a Salesforce Date/Time field . The query returns about 11K rows, most of which (10,100) do not have the field populated. The offending field is PC_Status_date__c
Code: Select all
SELECT P.Place_of_Service__c, A.Name,
P.Name, P.DOS_Scheduled__c, P.Status__c,
B.First_Name__c, B.Last_Name__c, P.PC_Status_date__c
FROM Patient_Choice_Case__c P
Inner Join Patient__c B on P.Patient__c = B.ID
Inner Join Account A on P.place_of_Service__c=A.ID
WHERE P.Place_of_Service__c In (
'0013600000wKnQ0',
'0013600000vFH1M')
I have tried to CAST & COALESCE - but no luck