3 Replies Latest reply: Jun 10, 2011 5:45 AM by Patrick Laredo RSS

    Use previous date when comparing shift data

      Hi

       

      I am trying to look at the activity of employees who work shifts which span across midnight each day. so if they work up to 4 am that is classed as the previous day.

       

      I have two fields

       

      Date

      Time

      In the script I want to add a new field Activity date.

      I have tried

      IF('00:00:00' < Time > '03:59:00', (date-1), date) as " Activity Date",

       

      but this doesn't work, am sure it's a simple syntax thing?

      Many thanks

      Matt