2 Replies Latest reply: Mar 3, 2016 11:34 AM by sreemannarayana g RSS

    Converting number to Text

    Adrian Buzer

      Hi

       

      I have a field called Time which is a numerical field.  If the time is 13:45:52 then the value will be 134552.  However, if the time is 00:03:24 then the value in the field is 324.  I would like it to show 000324 so that I can then use the maketime function to convert it back into a real time format.

       

      So how can I convert the number 324 into text '000324' in the load script? Or is there another way to convert 324 into a time?

       

      Thanks

      A.