Import Dates form csv to QlikView

[#1]

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]

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

[#3]

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]

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]

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]

maybe because you added some brackets:

hope this helps

regards

Marco