3 Replies Latest reply on May 27, 2017 7:33 PM by soco1509

    Dates in Case or If Statements

    soco1509

      hi,

       

      help would be greatly appreciated,

       

      in the data viewer while testing i wish to on the "fly" test results of date fields,

       

      i know this works

       

      Case(

      Aged WIP Report::Date >Aged WIP Report::test date;1;

      Aged WIP Report::Date = Aged WIP Report::test date;2;

      0)

       

      What i would like to do is, alter the xx/xx/xxxx in the case statement by entering actual dates, 01/02/2017 etc,

       

      Case(

      Aged WIP Report::Date >  xx/xx/xxxx;1;

      Aged WIP Report::Date = xx/xx/xxxx;2;

      0)

       

      can this be done?

       

      if so what would the syntax be?

       

      Regards

       

      Stephen