9 Replies Latest reply: Nov 2, 2016 2:30 PM by Massimo Grossi RSS

    How do I refer to LongMonthNames variable in script

    Cliff Clayman

      I would like to use the variable LongMonthNames in my script, but I cannot figure out what the syntax should be.


      Month(OrderDate) AS Month,


      This is what I currently have.  What do I need to change the variable to so I can utilize the Long Month Names variable that is created in the Main script?


      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
      SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';