4 Replies Latest reply on Sep 12, 2012 8:37 AM by EmilyDavis

    Date to Text Calculation - abbreviate month name

    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