How to give the date format?

Thu, 12 Nov 2015 17:11:35 GMT

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.

Re: How to give the date format?

oknotsen — Thu, 12 Nov 2015 17:13:28 GMT

date(Field, 'MMM-YYYY')

sunny_talwar — Thu, 12 Nov 2015 17:14:53 GMT

This should work for you:

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