AnsweredAssumed Answered

Need: Text as a Result of Date Range Calc

Question asked by sulu762 on Dec 30, 2011
Latest reply on Dec 30, 2011 by hbrendel

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.

Outcomes