14 Replies Latest reply: Apr 25, 2012 10:32 AM by Brian McKenna 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






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