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, Enrique. I am getting these excel files automatically, and trying not to introduce any manual steps to ready it for QlikView. Hoping to simply use code within QlikView to convert it to a datetime.