Help with a Date Field

[#1]

For some reason, Qlik seems to be having a hard time identifying and interpreting my date fields.

The field I have named date/time is showing my dates as:

Sep 9, 2014 11:54:02 PM PDT

Sep 10, 2014 12:14:19 AM PDT

So when loading the file, I have included these rows of script in my data load editor...

LOAD

    "date/time",

    DATE#("date/time",'MMM DD, YYYY hh:mm:ss tt') as Date,

Am I doing something wrong?

Is there something I should be putting for those last three characters that are for the time zone?

Corey

[#2 · Accepted solution]

Try :

Load

"date/time",

Date(DATE#(left("date/time",len("date/time")-4),'MMM DD, YYYY hh:mm:ss tt')) as Date

Best regards,

Xavier.

[its_anandrjs]

Hi,

Also try to covert this dates into Date format.

LOAD

    "date/time",

   DATE( DATE#("date/time",'MMM DD, YYYY hh:mm:ss tt') ,'MMM DD, YYYY hh:mm:ss tt' ) as Date,

Regards,

Anand

[#4]

Thanks so much for your help with this script.  This was my first request for assistance and I'm impressed. 

Again, much appreciated.

[#5]

good