topic Date Formats in QlikView

Date Formats

ramcena306 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In my application Qlikview is not recognizing date formats for particular years.

Original Field : PROD_CALMONTH with format YYYYMM as string.

derived field : PROD_DATUM_MONTH needs a proper data format.

PFA, it is showing date formats for all years except from 1900-1979.

kaushik.solanki‌chakshujain29 ‌jimhalpert ‌‌stalwar1 ‌

Regards,

Ramesh

Re: Date Formats

marcus_sommer — Tue, 18 Sep 2018 07:32:38 GMT

Try it with something like: date(date#(PROD_CALMONTH, 'YYYYMM')).

- Marcus

Re: Date Formats

ramcena306 — Tue, 18 Sep 2018 07:38:03 GMT

Hello Marcus,

I have already tried with this , but still facing the issue.

-Ramesh

Re: Date Formats

marcus_sommer — Tue, 18 Sep 2018 07:48:28 GMT

Please provide some more informations to how the rawdata and the related script-parts and the UI output look like and how it should be.

- Marcus

Re: Date Formats

jonathandienst — Tue, 18 Sep 2018 07:56:35 GMT

Are you sure that the year is a 4 digit number? 79 is the default windows cutoff for working out the century on a 2 digit year. So year 00 - 79 are assigned to 2000 while 80 - 99 are assigned to 1900.