Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Problems with date

Hi,

i have only one table and there is only one column "monDatum" with the same date 30.11.2016.

I use a script ("testKalender") to generate more date fields like Month etc. like "monMonat"

This is the result:

2016-12-01_19h45_33.jpg

Why "monMonat" doesn´t show "Nov" at the 1st row?

I don´t know where the numbers (42370) are came from AND here it shows a month.

What´s wrong?

regards,

sam

1 Solution

Accepted Solutions
homersimpson
Contributor II

Re: Problems with date

I have found the problem. In the excel file the date fields were formatted as "standard". Now I have the cells formatted as date and it works.

2016-12-01_22h52_33.jpg

Thanks

sam

4 Replies
MVP
MVP

Re: Problems with date

Try with this script:

LOAD

    Date(monDatum) as monDatum

FROM [lib://Lib1/nur-ein-datum.xlsx]

(ooxml, embedded labels, table is Tabelle1);

homersimpson
Contributor II

Re: Problems with date

Thanks, but i want like to know why this happend.

regards,

sam

MVP
MVP

Re: Problems with date

No idea, Qlik Sense should have picked this up as date without any help, but for some reason it did not. I am not sure why it did not

homersimpson
Contributor II

Re: Problems with date

I have found the problem. In the excel file the date fields were formatted as "standard". Now I have the cells formatted as date and it works.

2016-12-01_22h52_33.jpg

Thanks

sam