AnsweredAssumed Answered

Help with calculation greater than or less than

Question asked by kilbot on Apr 26, 2010
Latest reply on Apr 26, 2010 by philmodjunk

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

Outcomes