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

    Convert a bad string to a date

    Brian McKenna

      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

       

      Regards

       

      Tony

       

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