AnsweredAssumed Answered

Date to Text Calculation - abbreviate month name

Question asked by EmilyDavis on Sep 11, 2012
Latest reply on Sep 12, 2012 by EmilyDavis

Title

Date to Text Calculation - abbreviate month name

Post


     At the end of the day, I need a field that will export into Excel as text, formatted as a date.

     I have a Date Field
     I have a Calc Field that outputs text, and the calc looks at my Date Field

     MonthName ( Date Field) & " "
      & Day ( Date Field) & "," & " "
      & Year ( Date Field )

     It works great, and returns August 20, 2012.  However, I need to abbreviate the Month name, and turn it into Aug 20, 2012

      

Outcomes