1 Reply Latest reply on Sep 3, 2012 3:49 AM by Sorbsbuster

    Hour Range in calculation...

    GeoffreyMartin

      Title

      Hour Range in calculation...

      Post

      Hello,

      I've tried to look for thisand can't seem to find it and I'm striking out on my own.  

      I'm trying to set a calculation field to evaluate a field called HourofDay (0-23).  If the Hourofday >7 & <21 it should return "Day", otherwise it should return "Night".  This should be simple, but I'm having trouble making a simple case/ifthen statement out of this.

      Please help