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