topic convert date format in QlikView

convert date format

Sat, 29 Jan 2011 17:06:37 GMT

Dear friends,

how can convert the date 006.2010 in 30/06/2010??

in the table there is the period 006.2010 and I want convert in script to date 30/06/2010 and then manage this one in master calendar

can you help me

regards

gennaro

convert date format

Sat, 29 Jan 2011 19:45:50 GMT

I done in this way:

Directory; CO_PA: LOAD

MonthEnd(makedate((right(Periodo, 4)), (left(Periodo, 3)))) as Data,

//Calendar

LET varMinDate = Num(Peek('MinDate'));

LET varMaxDate = Num(Peek('MaxDate'));

LET vToday = num(today());

DROP TABLE MaxMinDate;

//*************** Temporary Calendar ***************

TempCalendar:

LOAD

$(varMinDate) + rowno() - 1 AS Num,

date($(varMinDate) + rowno() - 1) AS TempDate

AUTOGENERATE $(varMaxDate) - $(varMinDate) + 1;

//*************** Master Calendar ***************

MasterCalendar:

LOAD

TempDate AS Data,

Year(TempDate)as Anno,

Month(TempDate) as Mese,

Week(TempDate) as Settimana,

'Q' & Ceil(Month(TempDate)/3) as Quarter

but there's this error:

convert date format

rwunderlich — Sat, 29 Jan 2011 19:48:48 GMT

Can you explain a bit more how the period maps to the date? Is the period "006" month 6 and you want the monthend as date? Do you have 12 periods 1-12?

-Rob

convert date format

Sat, 29 Jan 2011 21:43:31 GMT

Hi Rob,

yes, all rigth

'006' is month 6 (june)

I want monthend 30/06/2010 and I have 12 period

thanks in advance

Re: convert date format

Anonymous — Wed, 11 Sep 2013 01:37:12 GMT

Hi, is that what you mean?

=MonthEnd( Date( Date#( '006.2010', '0MM.YYYY' ) ) )