2 Replies Latest reply on Mar 12, 2014 5:59 AM by Tom W

    group by hour

    Robert Oldershaw

      I'm looking to group production orders which are carried out throughout the day by the hour they were started. The field I have available to act on is a date/time field, e.g. 11/03/14 14:48, formatted as a date / time. I wish to do a calculation which states if the starting hour is between 5am and 5pm it is a day shift, else if not it is night shift but I'm struggling with the calculation. Any help would be gratefully received.