topic Import Dates form csv to QlikView in QlikView

Import Dates form csv to QlikView

Mon, 25 May 2015 06:08:23 GMT

Hi,

I have the following probleml. I have to import data from csv to Qlikview. Dates in csv look like: 3/11/2015 1:00:45 AM

(or M/DD/YYYY h:mm:ss AM).

The problem is that QV does not recognoze it like date and functions like date() or weekday() or date(num#()) on this field
don't return any value.

Please help.

Thanks,

Gysbert_Wassenaar — Mon, 25 May 2015 09:19:49 GMT

Try date(floor(timestamp#('3/11/2015 1:00:45 AM','M/DD/YYYY h:mm:ss TT')),'M/DD/YYYY')

Mon, 25 May 2015 10:31:55 GMT

Hi Gysbert,

expression

date(floor((timestamp#('3/11/2015 1:00:45 AM','M/DD/YYYY h:mm:ss TT')),'M/DD/YYYY'))

does not return anything.

maxgro — Mon, 25 May 2015 18:56:35 GMT

in a textbox the output of

=date(floor(timestamp#('3/11/2015 1:00:45 AM','M/DD/YYYY h:mm:ss TT')),'M/DD/YYYY')

in my QlikView is 3/11/2015

post some lines of csv file, if you can

Anonymous — Mon, 25 May 2015 22:00:27 GMT

Check the number of spaces here: '3/11/2015 1:00:45 AM'

and here: 'M/DD/YYYY h:mm:ss TT'

Make sure they are the same.

MarcoWedel — Wed, 01 Jul 2015 22:59:43 GMT

maybe because you added some brackets:

hope this helps

regards

Marco