Date to Text Calculation - abbreviate month name
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