0 Replies Latest reply: Jan 11, 2018 9:02 AM by Victor GREFFET RSS

    Loop for testing different columns

    Victor GREFFET

      Hi community !

      I need your help,

      In my script, i'd like to create a test on different type of date, and put a warning when the date is on Christmas or on the first of the year

      I have five differents type of dates :

       

      DATA :

      ID

      Step0Step1Step2Step5Step9

      1

      12/12/201710/12/201710/12/201718/12/201718/12/2017
      201/01/201710/12/201713/12/201718/12/201718/12/2017
      312/12/201710/12/201710/12/201725/12/201725/12/2017
      410/12/201710/12/201718/12/201718/12/201718/12/2017
      ........
      n12/12/201710/12/201710/11/201718/12/201718/12/2017

       

      What I want :

       

      DATA :

      IDStep0Step1Step2Step5Step9Test

      1

      12/12/201710/12/201710/12/201718/12/201718/12/2017ok
      201/01/201710/12/201713/12/201718/12/201718/12/2017Warning Step0 it's 01/01
      312/12/201710/12/201710/12/201725/12/201725/12/2017
      Warning Step5 it's 25/12 , Warning Step9 it's 01/01
      410/12/201710/12/201718/12/201718/12/201718/12/2017ok
      ........
      n12/12/201710/12/201710/11/201718/12/201718/12/2017

      ok

       

      Do you  have an idea ?

       

      Thank you !

      Victor