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.....