Convert Date

[ashishpalkar]

Hi There

How to convert this date into

05/22/2002 to May 2015

[qlikviewwizard]

Hi Use this script:

SETThousandSep=',';

SETDecimalSep='.';

SETMoneyThousandSep=',';

SETMoneyDecimalSep='.';

SETMoneyFormat='$#,##0.00;($#,##0.00)';

SETTimeFormat='h:mm:ssTT';

SETDateFormat='DD/MMM/YYYY';

SETTimestampFormat='M/D/YYYYh:mm:ss[.fff]TT';

SETMonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SETDayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Table:

LOAD * ,Date(Date#(Date, 'MM/DD/YYYY'), 'MMM YYYY') as NewDate;

LOAD * INLINE [Date

6/16/2015

5/16/2015

4/16/2015

3/16/2015

2/16/2015

1/16/2015

];

[ashwanin]

Date(MonthStart(AddYears(Date#('05/22/2002', 'MM/DD/YYYY'),13)), 'MMMM YYYY')

[qlikviewwizard]

Hi Ashish, Did you able to manage?