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

[Frank_Hartmann]

try using only this

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

hope this helps

[cliff_clayman]

No, I do not want to do that.  I want to use the LongMonthNames variable.

[Frank_Hartmann]

then use this:

=Date(Month,'MMMM')

hope this helps

[cliff_clayman]

What is the point of QlikView adding the LongMonthNames variable if I can't use it?

[Frank_Hartmann]

Date(Month,'MMMM') will call the longmonthname according your script!

[cliff_clayman]

You do not reference the field name in that code...

[Frank_Hartmann]

But by transforming into 'MMMM' Qlikview calls the Variable LongMonthNames in Script!

[cliff_clayman]

Okay, I used the following code:

Date(OrderDate,'MMMM') AS Month

I am getting multiple values for the months whereas I am only expecting one value for each month name.  When I use the original code,

Month(OrderDate) AS Month

I only get each individual month name.

Also, is the function called MonthsName used for long month names?  It appears to require 2 parameters.

[maxgro · Accepted solution]

try

Dual(      date(OrderDate, 'MMMM'),     Month(OrderDate))                     AS Month