2 Replies Latest reply: Nov 12, 2015 12:14 PM by Sunny Talwar RSS

    How to give the date format?

    Prashanth Reddy Nasi

      Hi,

      Date format issue.

      sample data:

      Inv date:(MM/dd/yyyy) Output am getting   Expected output

      10/01/2015                  Jan-2015                 Oct-2015

      10/02/2015                   Feb-2015                Oct-2015

      10/03/2015                   Mar-2015                Oct-2015

      10/04/2015                    Apr-2015                Oct-2015

      10/05/2015                    May-2015               Oct-2015

      10/06/2015                    Jun-2015                Oct-2015

      10/07/2015                    Jul-2015                 Oct-2015

      10/08/2015                    Aug-2015                Oct-2015

      10/09/2015                    Sep-2015                Oct-2015

      10/10/2015                    Oct-2015                Oct-2015

      10/11/2015                    Nov-2015                Oct-2015

      10/12/2015                    Dec-2015                Oct-2015

      10/13/2015                    Oct-2015                  Oct-2015

       

      from 10/13/2015 are storing in Oct month.