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

    Putting Dollar Expansion in Variable

    Bill Markham



      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