0 Replies Latest reply: Jul 17, 2012 8:54 PM by Fernando Obando

Hi all,

Solution statements:

Only for those records with topmost condition 08.* and the second condition counting from the top is 07.*,we need to identify the following 2 dates of change of condition: -corresponding date of topmost condition if 08.*, and; -corresponding date of condition 07.1

Record with ID A does not qualify as even thou its topmost condition is 08.2 (08.*), its second condition from the top is 08.1 (not 07.*)

Record with ID B does qualify as its topmost condition is 08.1 (08.*) and its second condition from the top is 07.2 (07.*); for this record we need to find the dates that correspond to condition 08.1 and 07.1 specifically (not 07.2)

Record with ID C does not qualify as, even thou its topmost condition is 08.2 (08.*), its second condition from the top is 08.1 (not 07.*)

Record with ID D does not qualify because its topmost condition is not 08.*

Record with ID E does qualify as its topmost condition is 08.1 (08.*) and its second condition from the top is 07.1 (07.*); for this record we need to find the dates that correspond to condition 08.1 and 07.1

 ID Condition Date of condition change A 08.2 F1 A 08.1 F2 A 07.3 F3 A 07.2 F4 A 07.1 F5 A 06.1 F6 A 05.1 F7 B 08.1 F8 B 07.2 F9 B 07.1 F10 B 06.1 F11 B 05.1 F12 C 08.2 F13 C 08.1 F14 C 07.1 F15 C 06.1 F16 C 05.1 F17 D 07.3 F18 D 07.2 F19 D 07.1 F20 D 06.1 F21 E 08.1 F22 E 07.1 F23

Expected Selections

 ID Date 1 Date 2 Result (substraction) B F8 F10 F8-F10 E F22 F23 F22-F23

Thanks,

Fernando Obando