month long names

[L_Hop]

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.

[sunny_talwar]

How about this

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

[jwjackso]

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]

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]

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