4 Replies Latest reply: May 14, 2015 7:08 PM by Sudheer Kumar Mukka RSS

    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...




          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?