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:
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?
Okay, I knew I'd figure this out as soon as I posted it. I had to uncheck the option "Don not replace existing value of field (if any)".