17 Replies Latest reply: Jul 2, 2014 5:49 AM by Viktor Marusak RSS

    Convert a bad string to a date

      I have a field that I'm trying to extract a date from.


      It's in the format, text February 2012 text.

      Using the functions subfield and mid I now have February 2012.

      How can I convert this to a date field, e.g. 01/02/2012






      Message was edited by: QlikQuest Thanks for the response. I'm not at the office but I've created  a similiar scenario. Thanks again.