0 Replies Latest reply: Sep 22, 2011 3:10 PM by suky dhak RSS

    IntervalMatch with Datetime

    suky dhak



      I have attached 1 file with 2 sample sheets. We have a production system that provides us the amount of qty created by each plant (key) If we have a problem and issues sheet is completed with the date time of the issue.


      I need to join this to the main summary sheet but have two issuess.


      1. some times the value in the main sheet is missing (ie we don't have a start datetime and end datetime )

      2. the other issue is the interval match does not work with datetime.


      Please could someone help.