Help with calculation greater than or less than
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.
= 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
New field = 1