Data Format, Date, Pattern

[jbanks2]

Within a date field I am setting Data Format, Date, Pattern to input the following:  'Terminated Date =' MM/dd/yyyy

My report outputs results into Excel 2007.  The following displays in my Terminated Date field:  TerminAM/PMted DAM/PMte = 02/19/2016.

Everywhere there is an "a" in Pattern the "a" is replaced with "AM/PM"...

Any idea why this is occurring. 

[navissar]

Can't tell you why it's happening - could be an Excel peculiarity - but can offer some advice how to side step it: Just add your text in a layout calculation in the cell.

[bdbits]

I don't think you can put literal text into format patterns. It certainly appears to be interpreting the letter 'a' as an AM/PM in your pattern.

Like Nimrod said, just add the text in a calculated expression and use that.