function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Dawn ShifflettDawn Shifflett 

Number of Opportunities in the last 3 fiscal years.

I need to see which donors have given 3 or more gifts in the last 3 fiscal years.  Can I use last N days for that, or is there another way to query?  Thanks!
VinayVinay (Salesforce Developers) 
Hi Dawn,

As per my understanding you want to query opportunities of last 3 fiscal years?

Thanks,
Dawn ShifflettDawn Shifflett
Yes, I need a list of donors who have given 3 or more gifts sometime within the last 3 fiscal years [cid:image001.png@01D97DA6.47119CC0] Dawn Shifflett Donor Services Manager PO Box 937 96 Laurel Hill Road Verona, VA 24482 Office: 540.213.8406 www.brafb.org │ Facebook │ Twitter │ E-Newsletters “Everyone Should Have Enough To Eat.”
prakash SFprakash SF
You can use Date Literal: LAST_N_FISCAL_YEARS:3