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

how to peek field values on the basis of comparision

Mohit Sahrma

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.......