0 Replies Latest reply: Oct 9, 2012 10:42 AM by Chris Hopkins RSS

    variable in within a variable help

    Chris Hopkins

      Hi, i need some help putting a variable into an expression.

      In my script i create the following variable..

       

      SET vCurrentYearFiscalStartDate =DATE(FirstDayCurrentFiscalYear);

       

      then also in the script i am using this expression..

       

       

       

      LET vItemCount_Listings =

      'COUNT({$<
      [it_target_type]={"Listings"},
      [ld_Dist]={"4"},
      [ld_Outlet_Check_Date]={">=01/07/2012 00:00:00"}>}
      [ld_Item_Description])';

       

      The above is hard coded with a date (01/07/2012 00:00:00), i want to replace this date with the variable created before it but i cant seem to get it working.

      Can anyone help please?