How can I trim the date on the left hand side and convert this into a date value?
Input Example: 18 May 2016 - 17 Mar 2017
Output example: 2016-05-18
(using the yyyy-MM-dd format)
I've tried using trimLeft() function but the Mapper Snap doesn't recognise this expression (see screenshot attached).
