Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
How about this
Concat(DISTINCT Date(SetDateYear(MonthStart(month), Year(Today()), 'MMMM'), ', ')
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
Hi Onur,
May be it helps you , It works for me:
=Date(Date#(GetFieldSelections(month),'MMM'),'MMMM')
Thanks,
Arvind Patil
Does this work even when you have multiple selections?
=Concat(Date(Date#(GetFieldSelections(month),'MMM'),'MMMM'), ', ')