Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Parameter Passing date

Hello,

I'm trying to pass a parameter to a Soql Query, below is the query but slightly confused on where i might be going wrong. Any help would be great.

DECLARE @dtDate datetime;
SET @dtDate = '1999-01-01';

--Select @dtDate

EXEC ( 'SELECT Quote_Reference_Number__c ,
Quote_Status__c ,
LastModifiedDate ,
LastModifiedById ,
Id FROM Opportunity WHERE LastModifiedDate > ?', @dtDate) AT sfdc_Prod
1 person has
this problem
+1
Reply