topic Re: Please help with converting the date format. in QlikView

Please help with converting the date format.

Wed, 08 Jan 2014 18:18:26 GMT

I have a date filed with date in myy format.

For Ex: date field called Monthend has the value 113,213,313,413......

How can I covert this into jan 2013,feb 2013,Mar 2013,Apr 2013..... format ?

Thanks.

swuehl — Wed, 08 Jan 2014 18:27:22 GMT

or maybe

=date(date#(num(Monthend,'0000'),'MMYY'),'MMM YYYY')

Anonymous — Wed, 08 Jan 2014 18:34:48 GMT

Hi,

You should load de data as follows :

Results:

LOAD MakeDate(2000+ Monthend - ( floor(Monthend/100)*100) , floor(Monthend/100) ) as date_result

FROM (biff, embedded labels, table is Blad1$);

and when you displays those you have to set the Format Pattern as 'MMM/YYYY' in the Number-tab.

PS: Is you are using dates from previous century, you should correct the formula.

PS2 : The solution by swuel is also working, and shorter , but I was preparing my answer when he replied.

Paul

Wed, 08 Jan 2014 18:41:38 GMT

Awesome.Thank you.