topic Re: Date format change in QlikView

Date format change

Fri, 20 Nov 2020 18:02:30 GMT

Hello everyone,

I have a problem with dates.

One table I load from an external source contains date: 2015-05-12 (so: YYYY-MM-DD), but the main table we use contains: DATUM 12-05-2015 (so DD-MM-YYYY).

How can I load date as DATUM and consequently change it to the right format?

Thanks in advance.

Re: Date format change

sunny_talwar — Tue, 12 May 2015 13:31:20 GMT

For your external source date you can do something like below to change to the main table's date format:

Date(Date#(ExternalSourceDateField, 'YYYY-MM-DD'), 'DD-MM-YYYY') as ExternalSourceDateField

I am guessing that what you are looking for? Let us know otherwise

Best,

Sunny

Re: Date format change

rubenmarin — Tue, 12 May 2015 13:33:39 GMT

Hi Maarten, you can use the Date#() funtion, wich would read dates with the format you specify, and the use Date() to set the format you want ie:

LOAD Date(Date#('2015-05-10', 'YYYY-MM-DD'), 'DD-MM-YYYY') as Datum

....

Re: Date format change

Anonymous — Tue, 12 May 2015 13:36:06 GMT

You can format date on load

LOAD
date(date#(DateField, 'YYYY-MM-DD')) as Date
From external source;

LOAD
date(date#(DATUMd, 'DD-MM-YYYY')) as Date
SELECT
...
FROM main table;

Re: Date format change

Tue, 12 May 2015 14:01:25 GMT

Hi Maartes, you can do:

LOAD

DATUM,

Date#(DateOfExternalSource,'DD-MM-YYYY') as RightFormat

from [External_Source]

I hope that help it!

Regards, Agustín

Re: Date format change

Wed, 13 May 2015 11:24:16 GMT

This answer worked, but I guess all the other answers are in the same context. Thank you!