Brian Dunning's FileMaker Custom Functions

dayOfWeek_AN_ML ( theDayOrDate ; language ; abbrev ; dayNum ; style )

Get a day name or abbreviation in any language supported by the CF, and/or the day number, starting from a date or day number or starting from a day name or abbreviation provided in any supported language. Supported languages are: English, French, Spanish, Italian and Portuguese.

  Average rating: 4.6 (23 votes) Log in to vote

François Goulet   François Goulet
Lizzy Logik Inc.
Not applicable

Share on Facebook Share on Twitter

  Sample input:
day_AL_ML ( "2014-11-19" ; "" ; "" ; "" ; "" ) >
day_AL_ML ( "2014-11-19" ; "Es" ; "" ; "" ; "" ) >
day_AL_ML ( "2014-11-19" ; "En" ; "" ; "" ; "" ) >
day_AL_ML ( "2014-11-19" ; "En" ; "" ; 1 ; "" ) >
day_AL_ML ( "2014-11-19" ; "Fr" ; 1 ; 2 ; 2 ) >
day_AL_ML ( "Wednesday" ; "Fr" ; "" ; "" ; 1 ) >
day_AL_ML ( "Quarta-Feita" ; "En" ; "" ; "" ; 2 ) >
day_AL_ML ( "3. MAR" ; "En" ; "" ; "" ; 2 ) >
  Sample output:
4
miércoles
Wednesday
4. Wednesday
04. MER
Mercredi
WEDNESDAY
TUESDAY

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

dayOfWeek_AN_ML ( theDayOrDate ; language ; abbrev ; dayNum ; style ) v.1

Get a day name or abbreviation in any language supported by the CF, and/or the day number, starting from a date or day number or starting from a day name or abbreviation provided in any supported language. Supported languages are: English, French, Spanish, Italian and Portuguese.

OPTIONS:

1. theDayOrDate: a date or a day name or day name abbreviation with or without a day number (1 or 01 for Sunday ... 7 or 07 for Saturday). day names and abbreviations must strictly match names and abbreviations found in the LISTS OF DAY NAMES or ABBREVIATIONS found in the CF. Please note however that abbreviations ending with a period will not compromise the CF's performance;

2. language: "EN" ; "FR" ; "ES" ; "IT" ; "PT" . Please note that leaving the language option empty will cause the CF to return only the day number;

3. abbrev: empty ("") to return the day name or "1" to return the day abbreviation;

4. dayNum: empty ("") to omit the day number prefix; "1" to return the day name prefixed by the day number - ex. 1. ; "2" to return the day number prefixed by a "0" - ex. 01.

5. style: "" returns the result in lowercase in all languages except English which is always returned in titlecase; "1" for titlecase; "2" for uppercase

########################

EX:
day_AL_ML ( "2014-11-19" ; "" ; "" ; "" ; "" ) > 4
day_AL_ML ( "2014-11-19" ; "Es" ; "" ; "" ; "" ) > miércoles
day_AL_ML ( "2014-11-19" ; "En" ; "" ; "" ; "" ) > Wednesday
day_AL_ML ( "2014-11-19" ; "En" ; "" ; 1 ; "" ) > 4. Wednesday
day_AL_ML ( "2014-11-19" ; "Fr" ; 1 ; 2 ; 2 ) > 04. MER
day_AL_ML ( "Wednesday" ; "Fr" ; "" ; "" ; 1 ) > Mercredi
day_AL_ML ( "Quarta-Feita" ; "En" ; "" ; "" ; 2 ) > WEDNESDAY
day_AL_ML ( "3. MAR" ; "En" ; "" ; "" ; 2 ) > TUESDAY

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.