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