AnsweredAssumed Answered

Calculation field and numbers

Question asked by AnnetteSteinberg on Jan 16, 2012
Latest reply on Jan 16, 2012 by AnnetteSteinberg


Calculation field and numbers


 Version 11.03 Windows


I have a calc field ( unstored/number)  that gives me the difference  between the two dates.  Works fine.  Then I've created another calc field (unstored/test) that if the age (or results of the first field) is less then or greater then certain numbers it puts in another number (used eventally as a cateogory to sort from).  My problem comes with numbers greater than 100 - it only looks at the first two numbers.  What should I include in my calc below to get around this problem?  Thanks for your help.

Case ( age of invoice  ≤ "30"; "30";
age of invoice   ≥  "31" and age of invoice ≤ "60";"60";
age of invoice   ≥   "61" and age of invoice ≤ "90" ;"90";
age of invoice  ≥ "90" ; "greater than 90")