Need: Text as a Result of Date Range Calc
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.