topic Re: Problems with loading the Dates in QlikView

Problems with loading the Dates

vadim_grab — Sat, 12 May 2018 07:15:16 GMT

Hi,All.

I encountered a problem with loading the dates.

I learned

but the problem was not solved!

Any ideas?

My Case:

CSV file with dates:

Load Script:

Result:

mikaelsc — Sat, 12 May 2018 07:45:26 GMT

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 — Sat, 12 May 2018 07:58:40 GMT

Thanks Mikael!