Help needed Formatting a "Date" Merge field for reports...
I'm using the Merge field option to insert dates on to various reports, e.g. "Mr. Jones will arrive on <<arrival_date>>"
The problem I have is the dates are always formatted as… "12/16/13" when printed. I need "December 16, 2013"
Unlike the Inspector's Formatting option available for fields on layouts, there is nothing that I can find for formatting a Merge field the same way. And unfortunately setting the date field's format on the Input layout to my example of "December 12, 2013" above still yields a "12/16/13" result in Preview/Print mode.
Any thoughts, suggestions, formulas? It would be greatly appreciated! Thanks