[SalesForce] Invalid bind expression type of String for column of type Date

dt = restReq.params.get('date');


 String s=string.valueOf(dt);

I am trying to convert date to string and i am getting this error.

Best Answer

That error means that your SOQL is trying to bind a Date field to a String value:

String s = String.valueOf(dt);
sobject[] records = [select ... from ... where somedatefield = :s];

Instead, you will want to make the variable a date:

Date d = DateTime.valueOf(dt);
sobject[] records = [select ... from ... where somedatefield = :d];

Note: You'll need to determine which DateTime method you need (e.g. DateTime.parse, etc) based on the date's format.

Related Solutions

[SalesForce] Error: Compile Error: Invalid bind expression type of String for column of type Decimal at line 395 column 176

The clause in your SOQL

where Month__c =: month and Year__c =: year and Reference_Number__c =: ref

and the error message

Invalid bind expression type of String for column of type Decimal at line 395 column 176

is most likely, as @Himanshu said that Reference_Number__c is a field of type Number but local variable ref is of type String. Change to:

where Month__c =: month and Year__c =: year and Reference_Number__c =: Decimal.valueOf(ref)

[SalesForce] Error: Compile Error: Invalid bind expression type of OpportunityLineItem

In your first SOQL, thou you are only querying for product codes, you will get back opportunity line item in the list.

List<OpportunityLineItem> ProdCode = [Select ProductCode from OpportunityLineItem where id IN: oli];

So, in your second SOQL you are passing OpportunityLineItem list instead of product codes.

List<Product2> Prod_Nam = [Select id,Product_Abb__c from Product2 where ProductCode IN: ProdCode];

to fix this, after your first query, iterate and store the product codes into a separate collection / array and use it in your second SOQL.

something like

List<String> ProdCodes = new List<String>();
List<OpportunityLineItem> olList = [Select ProductCode from OpportunityLineItem where id IN: oli];
for(OpportunityLineItem ol : olList){
    ProdCodes.add(ol.ProductCode);
}
List<Product2> Prod_Nam = [Select id,Product_Abb__c from Product2 where ProductCode IN: ProdCodes];

Best Answer

Related Solutions

[SalesForce] Error: Compile Error: Invalid bind expression type of String for column of type Decimal at line 395 column 176

[SalesForce] Error: Compile Error: Invalid bind expression type of OpportunityLineItem

Related Topic