How to query This Fiscal and Last Fiscal Year opportunities?

How to query This Fiscal and Last Fiscal Year opportunities.

You can use THIS FISCAL YEAR and LAST FISCAL YEAR date values to get the opportunities.

list<opportunity> opplist =[SELECT Id,closedate FROM Opportunity WHERE CloseDate = THIS_FISCAL_YEAR limit 10];

system.debug('opplist-->'+opplist);

list<opportunity> opplist2 =[SELECT Id,closedate FROM Opportunity WHERE CloseDate = LAST_FISCAL_YEAR limit 10];

system.debug('opplist2-->'+opplist2); 

https://help.salesforce.com/apex/HTViewHelpDoc?id=custom_dates.htm&language=en

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm?language=en

Posted in: apex,query This Fiscal and Last Fiscal Year opportunities in Salesforce,Salesforce,Salesforce examples,Salesforce Fiscal year recods,salesforce training,Visualforce examples,Visualforce Training