9 Replies Latest reply: Mar 5, 2015 12:47 PM by Hossein Ramshini RSS

    TIME#

    Bruce Tedder

      Hi All

       

      our DB stores the EDIT_TIME as a string like this 74533 for 07:45:33

       

      How do I convert this to hh:mm

       

      I have tried; Time(Time#(YN_EDIT_TIME, 'hhmmss'),'hh:mm') but its does not seem to work.