Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
L_Hop
Creator
Creator

month long names

Hello All;

I have month selection and I need to show the selected month in a long month name format. Like January, February ...

my month data is like: Jan, Feb, Mar, Apr, ..

date(month,'MMMM') show the long month name format but I need to show the selected months' long month names.

For to get the selected month I have tried:

'GetFieldSelections(month)' and than applied date function like below

'date(GetFieldSelections(month),'MMMM')' and it is not worked.

Do you have any suggestion for this issue.

regards;

Onur Y.

5 Replies
sunny_talwar

How about this

Concat(DISTINCT Date(SetDateYear(MonthStart(month), Year(Today()), 'MMMM'), ', ')

jwjackso
Specialist III
Specialist III

The Match function finds the index of Month in the MonthNames variable.  The SubField function uses the index to extract the field from the LongMonthNames.

=SubField(LongMonthNames,';',Match(Month, $(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39))))


If you don't have a calendar table, I would strongly recommend creating one.  It really helps displaying different date formats.  See How to create a Calendar

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Onur,

May be it helps you , It  works for me:

=Date(Date#(GetFieldSelections(month),'MMM'),'MMMM')

Thanks,

Arvind Patil

sunny_talwar

Does this work even when you have multiple selections?

zebhashmi
Specialist
Specialist

=Concat(Date(Date#(GetFieldSelections(month),'MMM'),'MMMM'), ', ')