0 Replies Latest reply: Dec 7, 2012 11:55 AM by Semir Shewayish RSS

    Using intervalmatch for dates and times

      Hi, I'm hoping someone can help please. This is my first post so I hope I have given enough information. I'm using QV 11 SR1 64bit.

       

      I have a table that defines some shift patterns. For each day there are three eight-hour shifts. The shifts are named blue, green and orange. Over a number of months the hours to which these shift colours relate change. E.g. in January orange could be 8 a.m. to 4 p.m.. but then in February orange could be midnight to 8 a.m. This is because the operators in these shifts stay with a particular shift colour but this then means they don't constantly work the same shift month after month.

       

      DateFromDateTo
      TimeFrom
      TimeTo
      Shift
      01/01/1231/01/1200:0108:00Blue
      01/01/1231/01/1208:0116:00Orange
      01/01/1231/01/1216:0100:00Green





      01/02/1229/02/1200:0108:00Orange
      01/02/1229/02/1208:0116:00Green
      01/02/1229/02/1216:0100:00Blue
      etc



       

       

      The operators log transactions (e.g. stock movements in a warehouse) and the date and time of the transaction are logged in a table. I want to be able to relate the date and time of the transaction to a shift colour. I was hoping that intervalmatch might be able to help but I'm not sure how to do this when I have a date range and a time range to be able to refer to a particular shift.

       

      Thanks.