I'm having issues converting a date/time field which displays as:"20120214 09:15:00" into 02/14/2012 09:15 AM.  I tried using 2 formulas to convert the string into a datetime value but they both failed.

 

i used "dateTimeValue({field from DB}) and also tried cDateTime({field from DB}). 

Can anybody tell me what i'm doing wrong here?  When i check the formula it passes but while trying to run the report, the report fails.

Thank you