4 Replies Latest reply: Oct 15, 2013 2:51 PM by Alan Farrell RSS

    Putting Dollar Expansion in Variable

    Bill Markham

      Hi

       

      I am setting a variable in the script for use later in Set Analysis, but have had issues with the Dollar Expansion;

       

      As in, this don't work :

      let vSetMTYesterday='[Day]={"<=$(=day(today()))"} ';

       

       

      But replacing the $ with ' & chr(36) & ' then it does work :

      let vSetMTYesterday='[Day]={"<=' & chr(36) & '(=day(today()))"} ';

       

       

      Is this what one would expect ?

       

      Is there a better way of doing this ?

       

       

      Best Regards,     Bill