1 Reply Latest reply on May 12, 2018 6:00 AM by Zhouyi Zhang

    How to Change Format of date in Month/Year format?

    Shreya Singhal

      I have a "Delivery Date", which is a short date in format dd-mmm-yy (e.g. 31-Dec-2016). Using the format  - Month/Year, I get the result as December 2016.

       

      I want to have abbreviation of the month as "Dec" for December. My desired result is "Dec 2016".

      Not able to change the format. I have tried using the Format, by right clicking on the variable, and then selecting Dates from Default in Header. It does not give all the date format options, only Automatic is available.

       

      Attaching a packaged workbook to understand it more clearly.