topic Re: Date format issue in QlikView

Date format issue

brijesh1991 — Tue, 17 Dec 2013 12:37:02 GMT

How to convert Date format : yymmdd into dd/mm/yyyy???

Your ideaes are highly appreciated. . .

Thanks and Regards,

Brijesh

Re: Date format issue

datanibbler — Tue, 17 Dec 2013 12:42:13 GMT

Hi Brijesh,

I know of two ways:

- You could set the date_format you want on the "Main" tab of the script - or set it just before that code and reset it afterwards or wherever

- You could use the DATE# function - that would probably have to look like this:

>>> Date(Date#, [field], 'yyyymmdd'), [required_format]) as ... <<<

The DATE# function just takes the data that comes from your data_source and interprets as a date - that format_parameter is the format in which it comes - and automatically makes it the internally used numeric - then you can go and format it in whatever date_format you want to have displayed.

HTH

Best regards,

DataNibbler

Re: Date format issue

brijesh1991 — Tue, 17 Dec 2013 13:15:52 GMT

Hey DataNibbler thanks. . .

But if my date is 110425 then it should be converted to 25/04/2011.

First two digits year, next two digits month and last two digits day.

So you mean to say if I will use this:: Date(Date#('110425', 'yymmdd'),'DD/MM/YYYY')

then Date should be 25/04/2011 ideally!

But qlikview gives : 25/01/2011

Re: Date format issue

rbecher — Tue, 17 Dec 2013 13:27:22 GMT

Use upper format codes:

Date#('110425', 'YYMMDD')

'mm' is for minutes..

- Ralf

Re: Date format issue

brijesh1991 — Wed, 18 Dec 2013 04:48:11 GMT

Thanks Ralf. . .

It worked!!!