5 Replies Latest reply on Jun 17, 2014 10:39 AM by FMNewbie

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

    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?