I have a little dilemma that I would like to get to the bottom of.  My system formats are Swiss French.  So quite normally defined date fields are almost always given in French, which is what I want.  However I have come across one date field that stubbornly is rendered in English.  I have verified that the file in question uses System Formats as does the file it originates from in Relationships.  Can someone tell why this field wont render in French and how can I troubleshoot this?

Date format of MM/DD/YYYY or different?

 

See if this helps.

 

Let ( [

Parts = Substitute ( DateField ; "/" ; " " ) ;

Month = LeftWords ( Parts ; 1 ) ;

Day = MiddleWords ( Parts ; 2 ; 1 ) ;

Year = RightWords ( Parts ; 1 )

] ;

Day & "/" & Month & "/" & Year

Sorry I should have been more specific. I have one field definition in this file which goes like this :

If(Events::DateEnd   =  ""  or Events::DateEnd = Events::DateStart ; "la journée du "  & Day ( Events Multi::DateStart ) & " "  & MonthName ( Events Multi::DateStart  )& " "  & Year ( Events Multi::DateStart ) ;

 "pour les journées du "  & Day ( Events Multi::DateStart  ) & " "  & MonthName ( Events Multi::DateStart  )& " "  & Year (Events Multi::DateStart  )  & " au " & Day ( Events Multi::DateEnd ) & " "  & MonthName ( Events Multi::DateEnd   )& " "  & Year ( Events Multi::DateEnd  )  & ".")

 

This field definition renders a result in English like this :

 

 

yet all the other month names in the same file originating from the same field "DateStart" are in French like this :

 

 

I can't figure out why this is inconsistent.

This might be a localization issue, but I haven't seen it mentioned before.

We have several members that are French, hopefully one of them can add insight.

 

There used to be a French FileMaker Forum, I'm not sure of the URL, but try this one Link

 

HTH

 

 

Lee

I finally found a solution for this problem with the following function

 

http://www.fmfunctions.com/functions_display_record.php?functionId=316

 

Ooof !