Discussion Board for collaboration related to QlikView App Development.
I encountered a problem with loading the dates.
Why don’t my dates work?
QlikView Date fields
but the problem was not solved!
CSV file with dates:
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
View solution in original post