9 Replies Latest reply on Jul 21, 2017 8:01 AM by beverly

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




      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,