2 Replies Latest reply: Oct 22, 2011 11:47 AM by Johan Adolfsson RSS

    I am stuck...filter out unwanted data

      Hi!

      I have a problem with filtering out unwanted data. I have two different tables with "timestamps" (dates and times), table1 and table2.

      I need to check if table table2 have direct preceeding or direct following timestamps of table1.

      If not then display those items in a third table otherwise ignore them.

      img.jpg

      I have tried making a "unique key" out of the fields id + date from/to + time from/to and use it in a NOT EXISTS() function.

      But I can not seem to get it to work right.

       

      Any help is appreciated.

       

      See attached file.

       

      Thanks