2 Replies Latest reply: Feb 12, 2014 3:53 AM by Niek Verbart RSS

Convert string AM/PM to legit Date format AM/PM

Niek Verbart Newbie
Currently Being Moderated



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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points