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'




      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?