This content has been marked as final. Show 4 replies
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...
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?