DayNameList ( LocaleID )

Returns a list of Day names according to the given LocaleID

Average rating: 4.1 (34 votes) Log in to vote

Theo Ros - Show more from this author

Sample input:

DayNameList ( "nl" )

Sample output:

"zondag¶maandag¶dinsdag¶woensdag¶donderdag¶vrijdag¶zaterdag¶zo¶ma¶di¶wo¶do¶vr¶za"

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

/* --------------------------------------------------------------------------------------------
Returns a list of Day 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 seven values in the list are the day names in full, the last seven 
values are the day names abbreviated.

This function is part of the FormatDateLocale () function

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

Let ( lcid = Left ( Lower ( Trim ( LocaleID ) ) ; 2 ) ;
  Case ( lcid = "nl" ;   // Dutch
    "zondag¶maandag¶dinsdag¶woensdag¶donderdag¶vrijdag¶zaterdag¶zo¶ma¶di¶wo¶do¶vr¶za" ; 

    lcid = "en" ;           // English
    "Sunday¶Monday¶Tuesday¶Wednesday¶Thursday¶Friday¶Saturday¶Sun¶Mon¶Tue¶Wed¶Thu¶Fri¶Sat" ;

    lcid = "ge" ;           // German
    "Sonntag¶Montag¶Dienstag¶Mittwoch¶Donnerstag¶Freitag¶Samstag¶Son¶Mon¶Die¶Mit¶Don¶Fre¶Sam" ;

    lcid = "fr" ;           // French
    "dimanche¶lundi¶mardi¶mercredi¶jeudi¶vendredi¶samedi¶dim¶lun¶mar¶mer¶jeu¶ven¶sam" ;

    lcid = "es" ;           // Spanish
    "domingo¶lunes¶martes¶miércoles¶jueves¶viernes¶sábado¶do¶lu¶ma¶mi¶ju¶vi¶sa" ;

    // if an empty LocaleID is given, use current Get ( SystemLanguage )
    Let ( dte = Date ( 7 ; 10 ; 2005 ) ;  // pick a Sunday
      DayName ( dte ) & "¶" & DayName ( dte + 1 ) & "¶" & DayName ( dte + 2 ) & "¶" & 
      DayName ( dte + 3 ) & "¶" & DayName ( dte + 4 ) & "¶" & DayName ( dte + 5 ) & "¶" & 
      DayName ( dte + 6 ) & "¶" & Left ( DayName ( dte ) ; 3 ) & "¶" &
      Left ( DayName ( dte + 1 ) ; 3 ) & "¶" & Left ( DayName ( dte + 2 ) ; 3 ) & "¶" & 
      Left ( DayName ( dte + 3 ) ; 3 ) & "¶" & Left ( DayName ( dte + 4 ) ; 3 ) & "¶" & 
      Left ( DayName ( dte + 5 ) ; 3 ) & "¶" & Left ( DayName ( dte + 6 ) ; 3 ) 
    )
  )
)

Returns a list of Day 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 seven values in the list are the day names in full, the last seven values are the day 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.

DayNameList ( LocaleID )

Comments

Support this website.

Support this website.