topic Re: create date question in QlikView

create date question

Wed, 16 Jul 2014 10:56:13 GMT

load ......

belegpos.date,

year(belegpos.date) as year,

month(belegpos.date) as month,

day(belegpos.date) as day,

.......

from belegpos.qvd;

now when put a lsitbox where i should see the years or months or days there is no data. why???

belegpos.date is in the qvd like: 15/04/11 (MM/DD/YY)

thanks

Re: create date question

tresB — Wed, 16 Jul 2014 11:00:00 GMT

Use parsing function date#() like:

load ......

belegpos.date,

Date(Date#(belegpos.date, 'MM/DD/YY')) as Date,

year(Date#(belegpos.date, 'MM/DD/YY')) as year,

month(Date#(belegpos.date, 'MM/DD/YY')) as month,

day(Date#(belegpos.date, 'MM/DD/YY')) as day,

.......

from belegpos.qvd

Re: create date question

Wed, 16 Jul 2014 11:20:36 GMT

hey

it seems that there are only the first 12 days of the month.

listbox:

day 1

......

end.

do you have an idea why?

Re: create date question

tresB — Wed, 16 Jul 2014 11:26:30 GMT

Month field is coming ok?

Re: create date question

Wed, 16 Jul 2014 11:35:58 GMT

yes

Re: create date question

tresB — Wed, 16 Jul 2014 11:38:28 GMT

Then, perhaps the data is so. Wait, i guess it should be 'DD/MM/YY' rather than 'MM/DD/YY'. Change the format code in date#() and try.

Re: create date question

ashfaq_haseeb — Wed, 16 Jul 2014 11:42:57 GMT

Hi,

If you have different date formats, Then I suggest you to use ALT function.

Regards

ASHFAQ

Re: create date question

Wed, 16 Jul 2014 11:51:56 GMT

yes right, it's DD//MM//YY. my bad

thanks for your help