topic Re: Convert Date in QlikView

Convert Date

ashishpalkar — Thu, 13 Aug 2015 21:57:59 GMT

Hi There

How to convert this date into

05/22/2002 to May 2015

Re: Convert Date

prabhu0505 — Thu, 13 Aug 2015 22:16:18 GMT

Date(Date#('05/22/2002', 'MM/DD/YYYY'), 'MMM YYYY')

Re: Convert Date

MarcoWedel — Thu, 13 Aug 2015 22:51:52 GMT

‌Fixed year offset +13?

Re: Convert Date

MarcoWedel — Thu, 13 Aug 2015 22:57:30 GMT

‌

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

regards

Marco

Re: Convert Date

MarcoWedel — Thu, 13 Aug 2015 22:59:43 GMT

‌Or

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

regards

Marco

Re: Convert Date

parthakk — Fri, 14 Aug 2015 05:18:42 GMT

Hi ashish,

The following part written in script allows you to dynamically get month name and year as 2015 in date format

MonthName(AddYears(DATE_FIELD_NAME,Year(Today())- Year(DATE_FIELD_NAME))) as new_date,

hope this helps you

Thanks,

Partha Kulkarni

Re: Convert Date

mohammadkhatimi — Fri, 14 Aug 2015 05:24:46 GMT

Hie...

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

Hope this will hepls you..!!

Regards,

Mohammad

Re: Convert Date

balasundaram — Fri, 14 Aug 2015 05:30:15 GMT

kindly you can use below expression too.

=monthname(addyears(date('05/22/2002'),13))

Re: Convert Date

senpradip007 — Fri, 14 Aug 2015 05:44:39 GMT

Have you reached your goal ? If no, please upload sample qvw as its a strange conversion as per my perspective.

Re: Convert Date

MarcoWedel — Fri, 14 Aug 2015 05:51:27 GMT

if you want the same month in the current year, then one solution could be:

MonthName(SetDateYear(Date#('05/22/2002', 'MM/DD/YYYY'),Year(Today())))

hope this helps

regards

Marco

Re: Convert Date

qlikviewwizard — Fri, 14 Aug 2015 05:59:10 GMT

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

];

Re: Convert Date

ashwanin — Fri, 14 Aug 2015 06:06:13 GMT

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

Re: Convert Date

qlikviewwizard — Fri, 14 Aug 2015 06:17:25 GMT

Hi Ashish, Did you able to manage?