AnsweredAssumed Answered

DayName and MonthName: return name of weekday/month in another language

Question asked by KBHLab on Jul 19, 2017
Latest reply on May 8, 2018 by Jean-Francois



I am using filemaker to schedule appointments and am trying to automate sending a confirmation email to my clients. With some clients I communicate in French, so I would like to email them the date with the weekday and month in French. For English, I use MonthName(Table::DateFieldName) which returns "July" if the date is in July, is there a way to get the French name for months, i.e. "Juillet"?

And if not, is there a better way than stringing multiple "if"-statements together? The only way I can thing of is

If(MonthName(Table::DateFieldName)="January","janvier, if MonthName(Table::DateFieldName)="February","fevrier"...etc

Many Thanks,