22 Replies Latest reply: Jun 17, 2014 7:03 AM by Naweed Alam RSS

    Date and Time to Time Only

      Help nothing works. I want to convert a date and time field to time only

       

      The field I'm converting always looks like this  with dates as 00/01/1900 with the time after ie

       

        00/01/1900 00:01:03

        00/01/1900 10:05:13

        00/01/1900 15:29:22

        00/01/1900 20:44:52

       

       

      nothing seems to extract the time only any ideas