AnsweredAssumed Answered

Help needed Formatting a "Date" Merge field for reports...

Question asked by SBC on Dec 18, 2013
Latest reply on Dec 18, 2013 by SBC

Title

Help needed Formatting a "Date" Merge field for reports...

Post

     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

Outcomes