Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
0

Questions
1

Replies

Compare year in where clause in SOQL

Hi all,

In my application i require to fetch data for the year entered by user using SOQL query,

In SOQL i tried the below code:

Code:

date sampleDate=Date.today();

//assume user have entered 2003
Integer diff=sampleDate.year()-2003;
Contact_log__c[] contactLog=[Select a.Id from Contact_log__c a where  a.Last_Import_ModifiedDate__c =(THIS_YEAR-:diff) order by a.Sequence_Number__c desc limit 1];

but i get syntax error , Please guide me.

Thanks in advance

djain
January 20, 2009
Like
0