4 Replies Latest reply: Feb 5, 2015 9:58 AM by Gysbert Wassenaar RSS

    Not able to check the condition

      Hi Friends,

       

      I have declared a variable like this 

       

      LET vAccountingPeriod=Date#(ADDMONTHS(YEARSTART(Now()),-12),'YYYYMM');

       

      Which is equal to 201401.

       

      and loaded the data like

       

      Load * from table

      where Date#([Acct-PrdOO],'YYYYMM')>Date#($(vAccountingPeriod),'YYYYMM');

       

      But I am getting all the data and  the check condition is failing.

       

      Please let me know the error in the code.....

       

      Thanks