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

Hi,

 

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

Legend

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