Calculation to find if get(current time) is between two time fields
This is probably something really simple, but I'm giving myself a migraine trying to make it work.
I need a calculation field, let's call it DutyStatus that determines if a person is on duty or not, based on a ShiftStart and ShiftEnd time. In other words, if get(currenttime) is between ShiftStart and ShiftEnd, make DutyStatus = "ON DUTY". If get(current time) is before ShiftStart or after ShiftEnd, then make DutyStatus = "OFF DUTY".
Any suggestions while I go find some more tylenol?