Newest functions Upload a function Leave a tip My account

There are 2,577 functions in this library.

CF_GetDayName ( SetDate ; LanguageCode ; SetLength )

Get the name of day in a specified language

  Average rating: 4.7 (18 votes) Log in to vote

Hans Nagelgast - Show more from this author None http://HTTP://none

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

// [LET START] Let ( [ $Date = GetAsDate ( SetDate ) ; $LanguageCode = If ( IsEmpty ( LanguageCode ) ; "EN" ; LanguageCode ) ; $Length = If ( IsEmpty ( SetLength ) ; 15 ; SetLength ) ] ; // CALCULATION Middle ( Case ( // DE = DEUTCH $LanguageCode = "DE" and DayOfWeek ( $Date ) = 1 ; "Sonntag" ; $LanguageCode = "DE" and DayOfWeek ( $Date ) = 2 ; "Montag" ; $LanguageCode = "DE" and DayOfWeek ( $Date ) = 3 ; "Dienstag" ; $LanguageCode = "DE" and DayOfWeek ( $Date ) = 4 ; "Mittwoch" ; $LanguageCode = "DE" and DayOfWeek ( $Date ) = 5 ; "Donnerstag" ; $LanguageCode = "DE" and DayOfWeek ( $Date ) = 6 ; "Freitag" ; $LanguageCode = "DE" and DayOfWeek ( $Date ) = 7 ; "Samstag" ; // EN = ENGLISH $LanguageCode = "EN" and DayOfWeek ( $Date ) = 1 ; "Sunday" ; $LanguageCode = "EN" and DayOfWeek ( $Date ) = 2 ; "Monday" ; $LanguageCode = "EN" and DayOfWeek ( $Date ) = 3 ; "Tuesday" ; $LanguageCode = "EN" and DayOfWeek ( $Date ) = 4 ; "Wednesday" ; $LanguageCode = "EN" and DayOfWeek ( $Date ) = 5 ; "Thursday" ; $LanguageCode = "EN" and DayOfWeek ( $Date ) = 6 ; "Friday" ; $LanguageCode = "EN" and DayOfWeek ( $Date ) = 7 ; "Saturday" ; // ES = ESPAÑOL $LanguageCode = "ES" and DayOfWeek ( $Date ) = 1 ; "Domingo" ; $LanguageCode = "ES" and DayOfWeek ( $Date ) = 2 ; "Lunes" ; $LanguageCode = "ES" and DayOfWeek ( $Date ) = 3 ; "Martes" ; $LanguageCode = "ES" and DayOfWeek ( $Date ) = 4 ; "Miércoles" ; $LanguageCode = "ES" and DayOfWeek ( $Date ) = 5 ; "Jueves" ; $LanguageCode = "ES" and DayOfWeek ( $Date ) = 6 ; "Viernes" ; $LanguageCode = "ES" and DayOfWeek ( $Date ) = 7 ; "Sábado" ; // FR = FRANÇAIS $LanguageCode = "FR" and DayOfWeek ( $Date ) = 1 ; "Dimanche" ; $LanguageCode = "FR" and DayOfWeek ( $Date ) = 2 ; "Lundi" ; $LanguageCode = "FR" and DayOfWeek ( $Date ) = 3 ; "Mardi" ; $LanguageCode = "FR" and DayOfWeek ( $Date ) = 4 ; "Mercredi" ; $LanguageCode = "FR" and DayOfWeek ( $Date ) = 5 ; "Jeudi" ; $LanguageCode = "FR" and DayOfWeek ( $Date ) = 6 ; "Vendredi" ; $LanguageCode = "FR" and DayOfWeek ( $Date ) = 7 ; "Samedi" ; // NL = NEDERLANDS $LanguageCode = "NL" and DayOfWeek ( $Date ) = 1 ; "Zondag" ; $LanguageCode = "NL" and DayOfWeek ( $Date ) = 2 ; "Maandag" ; $LanguageCode = "NL" and DayOfWeek ( $Date ) = 3 ; "Dinsdag" ; $LanguageCode = "NL" and DayOfWeek ( $Date ) = 4 ; "Woensdag" ; $LanguageCode = "NL" and DayOfWeek ( $Date ) = 5 ; "Donderdag" ; $LanguageCode = "NL" and DayOfWeek ( $Date ) = 6 ; "Vrijdag" ; $LanguageCode = "NL" and DayOfWeek ( $Date ) = 7 ; "Zaterdag" ; // No correct Language specified; defaults to English DayOfWeek ( $Date ) = 1 ; "Sunday" ; DayOfWeek ( $Date ) = 2 ; "Monday" ; DayOfWeek ( $Date ) = 3 ; "Tuesday" ; DayOfWeek ( $Date ) = 4 ; "Wednesday" ; DayOfWeek ( $Date ) = 5 ; "Thursday" ; DayOfWeek ( $Date ) = 6 ; "Friday" ; DayOfWeek ( $Date ) = 7 ; "Saturday" ) ; 1 ; $Length ) ) // [LET END] /* // [COMMENTS START] What it is? • In some cases the system language is not what you want • With this CF you can get the Day name in the selected language and in the required length • Hope this Custom Function comes in handy. Hans Nagelgast, Oss The Netherlands • http://www.briandunning.com/cf/1848 How does it work? (11-dec-2015) • CF_GetDayName ( "11-12-2015" ; "NL" ; 2 ) = Vr • CF_GetDayName ( "11-12-2015" ; "NL" ; 3 ) = Vri • CF_GetDayName ( "11-12-2015" ; "EN" ; 2 ) = Fr • CF_GetDayName ( "11-12-2015" ; "EN" ; 3 ) = Fri • CF_GetDayName ( "11-12-2015" ; "DE" ; 2 ) = Fr • CF_GetDayName ( "11-12-2015" ; "DE" ; 3 ) = Fre */ // [COMMENTS END] Click to copy

What it is?
• In some cases the system language is not what you want
• With this CF you can get the Day name in the selected language and in the required length
• Hope this Custom Function comes in handy. Hans Nagelgast, Oss The Netherlands
• http://www.briandunning.com/cf/1848

How does it work? (11-dec-2015)
• CF_GetDayName ( "11-12-2015" ; "NL" ; 2 ) = Vr
• CF_GetDayName ( "11-12-2015" ; "NL" ; 3 ) = Vri
• CF_GetDayName ( "11-12-2015" ; "EN" ; 2 ) = Fr
• CF_GetDayName ( "11-12-2015" ; "EN" ; 3 ) = Fri
• CF_GetDayName ( "11-12-2015" ; "DE" ; 2 ) = Fr
• CF_GetDayName ( "11-12-2015" ; "DE" ; 3 ) = Fre

 

Comments

		unix, Japan Jan 24, 2016
There need double quote to call CF_GetDayName ( "11-12-2015" ; "NL" ; 2 ) You can shorten the code using Choose() function. Case ( $LanguageCode = "DE" ; Choose ( DayOfWeek ( $Date ) - 1 ; ...

		Hans Nagelgast, None Jan 25, 2016
Thanks for your feedback

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: