How to give the date format?

[#1]

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.

[oknotsen]

date(Field, 'MMM-YYYY')

[sunny_talwar]

This should work for you:

Date(Date#([Inv date], 'MM/DD/YYYY'), 'MMM-YYYY') as [Expected Output]