3 Replies Latest reply on Apr 26, 2010 2:56 PM by philmodjunk

    Help with calculation greater than or less than

    kilbot

      Title

      Help with calculation greater than or less than

      Post

      I have a field that calculates the number of days a case has been open by subtracting the date closed from the date open, giving me a number.

       

      Example

      1/1/2010 opened

      1/6/2010 closed

      = 5 days

       

      I want to have a field that if the days opened field falls between 60 and a 120 it will give me a 1

      that way I can then have a summary field to count how many cases closed between 60 and a 120 days based on the date range I include

       

      Example:

      1/1/2010 opened

      2/14/2010 closed

      =74 days

       

      New field = 1

       

      thank you