Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
date(Field, 'MMM-YYYY')
This should work for you:
Date(Date#([Inv date], 'MM/DD/YYYY'), 'MMM-YYYY') as [Expected Output]
