2 Replies Latest reply: Nov 20, 2012 5:09 AM by eduqlikview RSS

    If (Date< 27/09/2012 ....



      I don't know how to use dates in an IF... Can you please help me? I want to plot this expression:


      count(if(Testserie=1 and if(DatumTag < 27/09/2012 , (L_Z1V1+L_Z1V2)/2<GW_MWZylS_OG_OLD, (L_Z1V1+L_Z1V2)/2<GW_MWZylS_OG_NEW),L_Z1V1))



      I copy the part of my skript where I declare the date:


      SET TimeFormat='hh:mm:ss';
      SET DateFormat='YYYY.MM.DD';
      SET TimestampFormat='YYYY.MM.DD hh:mm:ss[.fff]';
      SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
      SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

      LOAD Datum,
        Year (Datum) as Jahr,
        Month (Datum) as Monat,
        Day (Datum) as Tag,
        Hour (Datum) as Stunde,
        Minute (Datum) as Minute,
        Date(floor(Datum),'DD/MM/YYYY') as DatumTag,




      Thank you for your help!!!!