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

    Help with this please!

      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

       

      IDConditionDate of condition change
      A08.2F1
      A08.1F2
      A07.3F3
      A07.2F4
      A07.1F5
      A06.1F6
      A05.1F7
      B08.1F8
      B07.2F9
      B07.1F10
      B06.1F11
      B05.1F12
      C08.2F13
      C08.1F14
      C07.1F15
      C06.1F16
      C05.1F17
      D07.3F18
      D07.2F19
      D07.1F20
      D06.1F21
      E08.1F22
      E07.1F23

       

      Expected Selections

      IDDate 1Date 2Result (substraction)
      BF8F10F8-F10
      EF22F23F22-F23

       

      Thanks,

      Fernando Obando