2 Replies Latest reply: Dec 24, 2014 11:26 PM by mike BANNEN RSS

    HELP | Convert unusual string into Date, and Time

      Looked at lots of posts and am yet unable to convert the following into Date and Time fields.

       

      Field is called LASTORDERDATE

      Example value is: 01-APR-02 01.10.36.000000000 PM

       

      I need to convert to

      Date 04-01-2012

      Time: 01:10:36 PM (or 13:10:36)

       

      Any help is appreciated.