7 Replies Latest reply: Apr 19, 2012 9:55 AM by Aissam Boumejjane RSS

    problem with  end date using a LET variable

    Aissam Boumejjane

      Hi Guys,

       

       

      I have the following variable:

       

      LET vPeriod      =            date(Makedate(YEAR,Month,1),'YYYYMM');

       

       

      When I use one of these expression in my field date(Makedate(YEAR,Month,1),'YYYYMM') as Period, it works

      Now I want to create the end period using the Let statement 'vPeriod'

      Load

      year,

      month,

      Date(monthstart(addmonths('$(vPeriod)',12)),'YYYYMM') as EndPeriode

       

      From Database......

       

      I don't get any error when reloading. However no data can be found in the EndPeriode.

       

      What am I doing wrong?

       

      iSam