Sign Up ›
  • zuber Rangreaz
  • NEWBIE
  • 5 Points
  • Member since 2023
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
SOLVED
6 replies

SOQL Query on Account Opportunity to get the data from 2010 to 2016

HI

Can any one help me out in getting total count of opportunites between this years 2010 to 2016 which also needs accountname.

Thanks in Advance 
select id, Name, (Select id, Accountid, Createddate, stageName From Opportunities) From Account where stageName = '6 - Closed Won' AND createdDate > 2010-01-01T00:00:00Z and createdDate < 2016-01-31T23:59:59Z