7 Replies Latest reply: May 14, 2012 10:14 AM by adityatiwari RSS

    Create groups by Range of Days

      What is the best way to create groups in script outside of nested IF() statements using the delta between open and closed dates?  Example:  if(close date - open date < 10 days then 0 to 9, if( close date - open date is between 10 and 20 then 10 to 20, etc.....  How would you use the interval() function for this?