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

    Help with a Date Field

    Corey Creed

      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