Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
Thanks so much for your help with this script. This was my first request for assistance and I'm impressed.
Again, much appreciated.
good