8 Replies Latest reply: Aug 11, 2014 5:43 PM by Neal Alexander RSS

    Converting Text to DateTime

      I am receiving an excel file with date and time data on each record (e.g., Apr 21, 2013 10:15 PM).  I have tried to follow a number of the posts on this site on how to convert this to a datetime format within QlikView.  So far no luck.

       

      Can someone please provide me sample code on how to make convert this from text to a single datetime field?

       

      Thanks!