I would like to convert a string field including a date (2014-02-11 07:13:14 AM) into a legit date by using 'string to date' attribute. Unfortunately, I cannot transform these.
I've already tried to add a new date format to the standard list.
yyyy-MM-dd hh:mm:ss tt
However, above has not been accepted, and all dates cannot be transformed.
Thanks in advance for you help on this topic