How to change date format?

[#1]

Hi all ,

I am having two date formats in single column:

Invoicedate

01-Apr-2014

01-May-2014

01-Jun-2014

42006

42007

42008

42010

How to change change this format to single format i.e, MMM-YYYY(ex: Apr-2015)

thank you

[settu_periasamy]

May be like this..

Load Date(Alt( date#( Invoicedate , 'DD-MMM-YYYY' ),

  Date(Invoicedate),

  'No valid date' ),'MMM-YYYY') as Date;

LOAD * Inline [

Invoicedate

01-Apr-2014

01-May-2014

01-Jun-2014

42006

42007

42008

42010

];

[sunny_talwar]

Or this should also work

SET DateFormat='DD-MMM-YYYY';

Load DateMonthName(Invoicedate, 'MMM-YYYY') as MonthYear;

LOAD * Inline [

Invoicedate

01-Apr-2014

01-May-2014

01-Jun-2014

42006

42007

42008

42010

];

[maxgro]

with the alt function

load

     Date(alt(Date#(Invoicedate, 'DD-MMM-YYYY'), Invoicedate), 'MMM-YYYY') as Invoicedate

inline [

Invoicedate

01-Apr-2014

01-May-2014

01-Jun-2014

42006

42007

42008

42010

];

or, if you want the same result as Sunny

load Date(MonthStart(alt(Date#(Invoicedate, 'DD-MMM-YYYY'), Invoicedate)), 'MMM-YYYY') as Invoicedate

......