You need to sign in to do that
Don't have an account?

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

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