1 Reply Latest reply on Mar 1, 2013 1:46 AM by AllegroDataSolutions

    Calculating Time Range

    AllegroDataSolutions

      I am trying to calculate the value of a field named LengthOfStay as per the client's specs. LengthOfStay is a text field with a value list attached, which allows the user to select "Full Day" or "Half Day". If the user does not enter one of these values, it is determined by an auto enter calculation which derives the proper value from their start and end times (the fields TimeStart and TimeEnd). My formula looks like this:

       

       

      Case (

      IsEmpty ( TimeStart ) and IsEmpty ( TimeEnd );LengthOfStay;

      TimeEnd - TimeStart >10800;"Full Day";

      "Half Day" )

       

      Unfortunately, it always evaluates to "Half Day". Maybe I've been looking at this too long, but I can't figure out what I am doing wrong. Any ideas?

       

      Thanks.