Date Formats

[ramcena306]

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

[marcus_sommer]

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

- Marcus

[ramcena306]

Hello Marcus,

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

-Ramesh

[marcus_sommer]

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

[jonathandienst]

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.