MonthNameList ( LocaleID )

Returns a list of Month names according to the given LocaleID

Average rating: 3.8 (29 votes) Log in to vote

Theo Ros - Show more from this author

Sample input:

MonthNameList ( "nl" )

Sample output:

"januari¶februari¶maart¶april¶mei¶juni¶juli¶augustus¶september¶oktober¶november¶december¶jan¶feb¶mrt¶apr¶mei¶jun¶jul¶aug¶sept¶okt¶nov¶dec"

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* --------------------------------------------------------------------------------------------
Returns a list of Month names according to the given LocaleID

In: LocaleID - a string containing the Language ID

currently supported:
"nl" -> Dutch
"en" -> English
"ge" -> German
"fr" -> French
"es" -> Spanish

If the LocaleID parameter is an empty string, the systems Language is used.

Return type: Text (list separated by "¶")

The first twelve values in the list are the month names in full, the last twelve 
values are the month names abbreviated.

This function is part of the FormatDateLocale () function

Theo Ros
-------------------------------------------------------------------------------------------- */

Let ( lcid = Left ( Lower ( Trim ( LocaleID ) ) ; 2 ) ;
  Case ( lcid = "nl" ;   // Dutch
    "januari¶februari¶maart¶april¶mei¶juni¶juli¶augustus¶september¶oktober¶november¶december¶" & 
    "jan¶feb¶mrt¶apr¶mei¶jun¶jul¶aug¶sept¶okt¶nov¶dec" ; 

    lcid = "en" ;           // English
    "January¶February¶March¶April¶May¶June¶July¶August¶September¶October¶November¶December¶" & 
    "Jan¶Feb¶Mar¶Apr¶May¶Jun¶Jul¶Aug¶Sept¶Oct¶Nov¶Dec" ; 

    lcid = "ge" ;           // German
    "Januar¶Februar¶März¶April¶Mai¶Juni¶Juli¶August¶September¶Oktober¶November¶Dezember¶" & 
    "Jan¶Feb¶Mrz¶Apr¶Mai¶Jun¶Jul¶Aug¶Sept¶Okt¶Nov¶Dez" ; 

    lcid = "fr" ;           // French
    "janvier¶février¶mars¶avril¶mai¶juin¶juillet¶août¶septembre¶octobre¶novembre¶décembre¶" & 
    "jan¶fév¶mar¶avr¶mai¶juin¶juil¶août¶sept¶oct¶nov¶déc" ; 

    lcid = "es" ;           // Spanish
    "enero¶febrero¶marzo¶abril¶mayo¶junio¶julio¶agosto¶septiembre¶octubre¶noviembre¶diciembre¶" & 
    "ene¶feb¶mar¶abr¶may¶jun¶jul¶ago¶sept¶oct¶nov¶dic" ; 

    // if an empty LocaleID is given, use current Get ( SystemLanguage )
    MonthName ( Date ( 1 ; 1 ; 2005 ) ) & "¶" & MonthName ( Date ( 2 ; 1 ; 2005 ) ) & "¶" & 
    MonthName ( Date ( 3 ; 1 ; 2005 ) ) & "¶" & MonthName ( Date ( 4 ; 1 ; 2005 ) ) & "¶" & 
    MonthName ( Date ( 5 ; 1 ; 2005 ) ) & "¶" & MonthName ( Date ( 6 ; 1 ; 2005 ) ) & "¶" & 
    MonthName ( Date ( 7 ; 1 ; 2005 ) ) & "¶" & MonthName ( Date ( 8 ; 1 ; 2005 ) ) & "¶" & 
    MonthName ( Date ( 9 ; 1 ; 2005 ) ) & "¶" & MonthName ( Date ( 10 ; 1 ; 2005 ) ) & "¶" & 
    MonthName ( Date ( 11 ; 1 ; 2005 ) ) & "¶" & MonthName ( Date ( 12 ; 1 ; 2005 ) ) & "¶" & 
    Left ( MonthName ( Date ( 1 ; 1 ; 2005 ) ) ; 3 ) & "¶" & Left ( MonthName ( Date ( 2 ; 1 ; 2005 ) ) ; 3 ) & "¶" & 
    Left ( MonthName ( Date ( 3 ; 1 ; 2005 ) ) ; 3 ) & "¶" & Left ( MonthName ( Date ( 4 ; 1 ; 2005 ) ) ; 3 ) & "¶" & 
    Left ( MonthName ( Date ( 5 ; 1 ; 2005 ) ) ; 3 ) & "¶" & Left ( MonthName ( Date ( 6 ; 1 ; 2005 ) ) ; 3 ) & "¶" & 
    Left ( MonthName ( Date ( 7 ; 1 ; 2005 ) ) ; 3 ) & "¶" & Left ( MonthName ( Date ( 8 ; 1 ; 2005 ) ) ; 3 ) & "¶" & 
    Left ( MonthName ( Date ( 9 ; 1 ; 2005 ) ) ; 3 ) & "¶" & Left ( MonthName ( Date ( 10 ; 1 ; 2005 ) ) ; 3 ) & "¶" & 
    Left ( MonthName ( Date ( 11 ; 1 ; 2005 ) ) ; 3 ) & "¶" & Left ( MonthName ( Date ( 12 ; 1 ; 2005 ) ) ; 3 ) 
  )
)

Returns a list of Month names according to the given LocaleID

In: LocaleID - a string containing the Language ID

currently supported:
"nl" -> Dutch
"en" -> English
"ge" -> German
"fr" -> French
"es" -> Spanish

If the LocaleID parameter is an empty string, the systems Language is used.

Return type: Text (list separated by "¶")

The first twelve values in the list are the month names in full, the last twelve values are the month names abbreviated.

This function is part of the FormatDateLocale () function

Theo Ros

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

MonthNameList ( LocaleID )

Comments

Support this website.

Support this website.