4 Replies Latest reply: Feb 19, 2013 8:09 AM by Mohit Sharma RSS

    how to peek field values on the basis of comparision

    Mohit Sharma

      hii guys. i tried a lot for getting the time between  but can't get success on script side

       

      TAKE AN EXAMPLE....

      i have one table

      A:

      LOAD PAYCODE,

      TR_LUNCHSTARTTIME,

         TR_LUNCHENDTIME,

      ACYUALIN,ACTUALOUT

      FROM TABLE;

      JOIN(A)

      LOAD CARDNO as PAYCODE,

      TIME(OFFICEPUNCH)AS MOVMENT

      from table2;

      there i want a MOVMENT i.e my time field and i want to peek that values from MOVMENT which are greater than ACTUALIN AND Less than LUNCHSTARTTIME

      (min and max)

      after that i want also peek those values which are greater than TR_LUNCHENDTIME and less than ACTUALOUT

      HAVE AN EXAMPLE I HAVE MOVMENT OF PAYCODE

      MOVMENT
      08:43:00
      10:58:00
      13:17:00
      18:13:00

      and

      ACTUALIN
      08:43:00

      and

      ACTUALOUT
      18:13:00

      now i would like in pivot table

       

      10:58:00

      13:17:00

       

      here,lunch time is 1:00:00 to 2:00:00,if in MOVMENT GETTING two times between LUNCHSTARTTIME & LUNCHENDTIME

      so, i didnt want the values of MOVMENT between them....

      like

       

      MOVMENT
      08:43:00
      10:58:00

      13:17:00

      13:47:00

      18:13:00

      there i want only 10:58:00 -

       

      thanks in advance.......