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.