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';