Whether you're working in Cognos, Pentaho or some other BI tool, you'll inevitably be given a data element with a date format your system doesn't like. Usually it involves a month abbreviation and having to convert it to a number. Not all formula languages provide this type of conversion with a built-in command. The first solution that usually comes to…