Problems with loading the Dates

[vadim_grab]

Hi,All.

I encountered a problem with loading the dates.

I learned

Why don’t my dates work?

QlikView Date fields

but the problem was not solved!

Any ideas?

My Case:

CSV file with dates:

Load Script:

Result:

[mikaelsc · Accepted solution]

in your timestamp#, you don't provide a string format

floor(date#(... will not work. date# is an interpretation function, not a formatting function.

you'd need to date(floor(num(date#()))  (interpret, format as num, floor, format as date)

easiest i think, woul be to interpret and format your field as a timestamp, then calculate whatever you need:

timestamp(timestamp#(YourField,'DD.MM.YYYY hh:mm')) as TimeStampOfYourField

then, calculating dates, months, years, ... would be:

date(floor(TimeStampOfYourField))                              as DateOfYourTimestampField

etc

[vadim_grab]

Thanks Mikael!