DateTime issue. My results give Text and Numeric in same field? Can't convert to date, only int/num

[Ja123__]

Hi Everyone

When I import my date into qlik from a CSV, the field has the tag numeric only. It contains date time data.

I have tried converting in a few ways but I can see that qlik is seeing two different types of data. When I try convert to text, remove spaces and then split into the date format it shows two alignments on the field. So text and numeric?

Has this ever happened to anyone? The CSV is large and am struggling to open it anywhere outside of QlikSense at the moment.

I just want the date, 'DD/MM/YYYY'...

James

[santhiqlik]

Hi,

Try using this in load script to convert to date..

Date(Date#(field name,'DD/MM/YYYY'))

[Ja123__]

Thank you for responding.

I have tried that as well as even loading left(Date,4) as year, doing the same for month and year. For each part. Then loading in another table as makedate() using year, month and day. 

Still, I only get numeric fields which is why I am so stuck in this case. The origin of this data before it was a CSV extract was MySQL where it reflects as datetime.

[Ja123__]

This is a zippedQVD Extract of the Date column that I am struggling to convert