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
harry63harry63 

opportunities open for next 120 days?" URGENT PLZ HELP ME

Hi
i have a question that "Is it possible to populate a custom field on Accounts object that shows the number of opportunities open for next 120 days?"
I tried for rollup summaries but the filter criteria is not accepting the function today()+120.it is only taking standard date format.

THANKS IN ADVANCE

Steve :-/Steve :-/

I think you might have to set a custom field on the Opportunity record (like a 0/1, Checkbox, etc.) and then refernce the in your Account.Opportunity Roll-Up Summary field.  

 

Like COUNT of Opportunities where (custom field) = TRUE