In French, the first day of the month should be formatted like this "le 1er juin 2012" even if all the other days of the month don't take a suffix and are like this "le 2 juin 2012". FM's date formatting functions don't allow this. However i 'm sure there is a calculation or a custom function that could do the trick, I just can't figure out how to do it. If anyone has any ideas to get me started, I'd love to here them.

Try this:

let (



[ myDay = Day ( myDate ) ;



myYear = Year (myDate ) ;



myMonthName = MonthName (myDate ) ;



theSuffix = if ( Day ( myDate ) = 1 ; "er " ; " " ) ] ;



"le " & myDay & theSuffix & myMonthName & ", " & myYear



)

Put it in a Custom Function as e.g. FormattedDate ( myDate ).

Note that Month name uses the date settings of your system, so you must extend this

if you wanted to always get the month name in French, regardless of the user's settings.

Great. Thanks a lot. That works like a charm.

For a widely international solution to this problem, check out http://www.fmfunctions.com/functions_display_record.php?functionId=316