AnsweredAssumed Answered

Calculation to find if get(current time) is between two time fields

Question asked by FMNewbie on Jun 17, 2014
Latest reply on Jun 17, 2014 by FMNewbie

Title

Calculation to find if get(current time) is between two time fields

Post

     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?   

Outcomes