Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Help with a Date Field

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

1 Solution

Accepted Solutions
Not applicable

Re: Help with a Date Field

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.

4 Replies
Not applicable

Re: Help with a Date Field

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.

Re: Help with a Date Field

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

Not applicable

Re: Help with a Date Field

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

Again, much appreciated.

Not applicable

Re: Help with a Date Field

good

Community Browser