+ Start a Discussion
swaranswaran 

URGENT HELP REQUIRED ON SFDC QUERY IN JAVA

Hi

 

I have an requirement to compare createddate with system date. I know in Apex coding we can do using system.today() method.

 

In Java, I have query on case object. this query should retrive the records created on that day itself.

 

my query is

 

binding.query("select id,CaseNumber,BRAND_del__c,Account.City_dealer__c,Tenure__c,Account.Dealer_Code_FINNONE__c,Mobile__c,Age__c,Gross_Loan_Amount__c,Advanced_EMI_Amount__c,CreatedDate from Case where Count_of_Fraud_Records__c=0 and CreatedDate=system.today() limit 1");

 

Can you please help me in writing this filter condition?

 

Thanks in advance.

 

Regards,

Swaran