Nominal to Date

maccten

Hi,

I have a time stamp field which unfortunately is set as a text field in the DB I am using
I wish to convert this using the "Nominal to Date" Operator but am having some difficulties
An example of a date is 10/23/12 01:19PM

I set the operator to time_stamp and set the time stamp as mm/dd/yy hh:mm

This isn't working and i suspect its because my understanding of the parsing is a bit on the flawed side

Can anyone help

Thanks in advance

MariusHelf

The parsing does work
However, have a look at http://docs.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html for reference and try something like:

MM/dd/yy hh:mma

(not tested, but based on the linked site you will manage to get it right )

Best regards,
Marius