Date format from csv

[Anonymous]

Hello,

I have csv file with format date like 1/2/2012 15:27

Qlikview recognises it like text.

I used load script

date(date#(created_at,'YYYY-MM-DD')) as creationdate1,

It didn't work.

Who knows what should to do?

Thanks,

[Anonymous]

I downloaded a new file and the date format shows like 

2011-05-16 10:33:58 -0400

2011-05-16 12:29:31 -0400

2011-05-16 14:25:00 -0400

2011-05-16 19:30:45 -0400

2011-05-16 20:42:34 -0400

2011-05-17 18:56:56 -0400

2011-05-18 11:22:20 -0400

2011-05-18 16:28:25 -0400

2011-05-19 13:12:39 -0400

How to remove UTC time?

I use

date(timestamp#(created_at, 'M/D/YYYY hh:mm:ss'), 'YYYY-MM-DD') as creationdate,

What's the code for UTC?

Thanks,

[Anonymous]

???

[rustyfishbones]

try

DATE(created_at) AS created_at