Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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

 

 

 

mpiercempierce
See the SOQL documentation: http://www.salesforce.com/us/developer/docs/api/index_Left.htm#StartTopic=Content%2Fsforce_api_calls_soql_select_dateformats.htm|SkinName=webhelp
Message Edited by mpierce on 11-27-2009 12:29 AM