4 Replies Latest reply on Dec 30, 2011 8:21 AM by hbrendel

    Need: Text as a Result of Date Range Calc

    sulu762

      Title

      Need: Text as a Result of Date Range Calc

      Post

      I'm trying get the text "On Leave" when the DateBegan is less than or equal to CurrentDate and the CurrentDate is less than DateReturned.  Here's my calc so far:

       

      Case ( DateBegan  ≤  Get ( CurrentDate )  <  DateReturned ; "On Leave" )

       

      When I test the calc, it works outside of those parameters.  I've tried other recommendations on the forum, but been at this for five hours now.  What am I doing wrong?

      I'm not storing the results, this is not a global field, and I have set the field to store results as text.

      I'm going to bed.  Thank you in advance.